REDACTION_COLUMNS
describes all redacted columns in the database, giving the owner of the table or view within which the column resides, the object name, the column name, the type of redaction function, the parameters to the redaction function (if any), and an optional description of the redaction policy.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the object that is redacted |
|
|
|
Name of the object that is redacted |
|
|
|
Name of the column that is redacted |
|
|
Redaction function for this column |
|
|
|
Redaction function_parameters for this column |
|
|
|
Regular expression pattern to search for |
|
|
|
Replacement string (up to 4000 characters in length) with up to 500 back-references to subexpressions in the form |
|
|
|
Integer counting from 1, giving the position where the search should begin |
|
|
|
Either |
|
|
|
To change the default matching behavior, possible values are a combination of |
|
|
|
User-provided description of the redaction function that is performed on the column. For example, for a Social Security Number column, the description might be: "redact SSN to XXX-XX-(last 4 digits)". |
See Also:
Oracle Database Advanced Security Guide for more information about Oracle Data Redaction