Tag: redaction

Oracle Redaction details in the database

The dba tables in Oracle that display the redaction information (Oracle Advanced security) are redaction_columns & redaction_policies tables.

PUBLIC.redaction_columns
PUBLIC.redaction_policies
SYS.redaction_columns
SYS.redaction policies
SELECT * FROM redaction_columns;

OBJECT_OWNER|OBJECT_NAME|COLUMN_NAME|FUNCTION_TYPE|FUNCTION_PARAMETERS|REGEXP_PATTERN|REGEXP_REPLACE_STRING|REGEXP_POSITION|REGEXP_OCCURRENCE|REGEXP_MATCH_PARAMETER|COLUMN_DESCRIPTION|

SELECT * FROM redaction_policies;

OBJECT_OWNER|OBJECT_NAME|POLICY_NAME|EXPRESSION|ENABLE|POLICY_DESCRIPTION|

Advertisement