DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.REDACTION_COLUMNS

Object Details
Object Name: REDACTION_COLUMNS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All Redacted Columns in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_OWNER VARCHAR2 (128) Yes Owner of the table, or view
OBJECT_NAME VARCHAR2 (128) Yes Name of the table, or view
COLUMN_NAME VARCHAR2 (128) Yes Name of the column
FUNCTION_TYPE VARCHAR2 (27)
Redaction function type defined for this column
FUNCTION_PARAMETERS VARCHAR2 (1000)
Redaction function parameters defined for this column
REGEXP_PATTERN VARCHAR2 (512)
Parameter for any Regular Expression based Redaction defined for this column
REGEXP_REPLACE_STRING VARCHAR2 (4000)
Parameter for any Regular Expression based Redaction defined for this column
REGEXP_POSITION NUMBER

Parameter for any Regular Expression based Redaction defined for this column
REGEXP_OCCURRENCE NUMBER

Parameter for any Regular Expression based Redaction defined for this column
REGEXP_MATCH_PARAMETER VARCHAR2 (10)
Parameter for any Regular Expression based Redaction defined for this column
COLUMN_DESCRIPTION VARCHAR2 (4000)
Description of the redaction policy on this column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJECT_OWNER
,      OBJECT_NAME
,      COLUMN_NAME
,      FUNCTION_TYPE
,      FUNCTION_PARAMETERS
,      REGEXP_PATTERN
,      REGEXP_REPLACE_STRING
,      REGEXP_POSITION
,      REGEXP_OCCURRENCE
,      REGEXP_MATCH_PARAMETER
,      COLUMN_DESCRIPTION
FROM SYS.REDACTION_COLUMNS;

Dependencies

[top of page]

SYS.REDACTION_COLUMNS references the following:

SchemaSYS
TableCOL$
TableOBJ$
TableRADM$
TableRADM_CD$
TableRADM_MC$
TableUSER$
SYS.REDACTION_COLUMNS is referenced by following:

SchemaPUBLIC
SynonymREDACTION_COLUMNS