Image redaction_create.gif shows the Create Data Redaction Policy page. At the top, from left to right, the components are:
At the top is the label Create Data Redaction Policy : SALES_OPPS_POL.
To the far right of this label are the Cancel, Show SQL, and Ok. buttons.
Following the label, from to top bottom, are the fields Schema, Table/View, Policy Name, and Policy Expression. To the right of the Schema and Table/View fields are search icons so that you can look up these values and select them from a list. To the right of the Policy Expression field is an expression builder icon.
To the right of these fields are the following instructions: Policy expression can be based on SYS_CONTEXT values from a specific namespace such as USERENV or SYS_SESSION_ROLES. Also boolean expressions that always evaluate to TRUE/FALSE can be specified. Example:
- SYS_CONTEXT('USERENV','SESSION_USER')='APP_USER'
- SYS_CONTEXT('SYS_SESSION_ROLES','SUPERVISOR')='FALSE'
- '1=1' (Default expression which evaluates to TRUE)
Following the set of fields is the Object Columns area, which has, from left to right, the Format list, Add button, Modify button, Remove button, and Detach button. Following these buttons is a table that lists the currently configured columns for this policy. It has the columns Column, Column Datatype, Redaction Function, and Function Attributes.