REDACTION_POLICIES

REDACTION_POLICIES displays all redaction policies in the database.

Column	Datatype	NULL	Description
`OBJECT_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object with the policy
`OBJECT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object with the policy
`POLICY_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the policy
`EXPRESSION`	`VARCHAR2(4000)`	`NOT NULL`	Expression for this policy
`ENABLE`	`VARCHAR2(7)`		Indicates whether the policy is enabled (`YES`) or not (`NO`)
`POLICY_DESCRIPTION`	`VARCHAR2(4000)`		Description of the policy

Note:

This view is available starting with Oracle Database 11g Release 2 (11.2.0.4).