Home > Data Modeler Dialog Boxes > Mask Templates Administration
This dialog box is displayed if you click Tools, then Mask Templates Administration. It lets you create one or more "templates" that you can then associate with appropriate columns in tables in a relational model.
Oracle Data Redaction, a part of Oracle Advanced Security, enables you to mask (redact) data that is queried by low-privileged users or applications. Redaction policies can be applied to table columns.
Available Mask Templates: Lists any mask templates that are available to be assigned to a column of a suitable data type (using the Security tab under Columns under Table Properties).
Buttons: Add lets you create a new mask template; Remove deletes the selected mask template; Modify lets you edit the selected template; Apply applies any changes you have made to the selected template.
Name: Name for the mask template
Function Type: PARTIAL
(Partial redaction, redact a portion of the column data) or REGEXP
(Regular expression based redaction).
If Function Type is PARTIAL
: Datatype can be Character, Numeric, or Date. (Remaining fields depend on the data type.)
If Function Type is REGEXP
, the remaining fields are Pattern, Replace String, Position, Occurrence, and Match Parameter.
For more detailed information about redaction and masks, see the following:
"Oracle Data Redaction" section in the "Topics for Database Administrators and Developers" chapter in Oracle Database Concepts.
DBMS_REDACT
package information in Oracle Database PL/SQL Packages and Types Reference.