VIEW: SYS.REDACTION_COLUMNS

Source

View Text - Preformatted

select u.name                                           object_owner,
       o.name                                           object_name,
       c.name                                           column_name,
       DECODE(rc.MFUNC, 0, 'NO REDACTION',
                        1, 'FULL REDACTION',
                        2, 'PARTIAL REDACTION',
                        3, 'FORMAT PRESERVING REDACTION',
                        4, 'RANDOM REDACTION',
                        5, 'REGEXP REDACTION',
                           'UNSUPPORTED REDACTION')     function_type,
       rc.mparams                                       function_parameters,
       rc.regexp_pattern                                regexp_pattern,
       rc.regexp_replace_string                         regexp_replace_string,
       rc.regexp_position                               regexp_position,
       rc.regexp_occurrence                             regexp_occurrence,
       rc.regexp_match_parameter                        regexp_match_parameter,
       rd.cdesc                                         column_description
  from radm$    r,
       radm_mc$ rc,
       radm_cd$ rd,
       obj$     o,
       user$    u,
       col$     c
 where r.obj#     = o.obj#
   and o.owner#   = u.user#
   and rc.intcol# = c.intcol#
   and rc.obj#    = r.obj#
   and c.obj#     = o.obj#
   and rc.obj#    = rd.obj#(+)
   and rc.intcol# = rd.intcol#(+)

View Text - HTML Formatted

SELECT U.NAME OBJECT_OWNER
, O.NAME OBJECT_NAME
, C.NAME COLUMN_NAME
, DECODE(RC.MFUNC
, 0
, 'NO REDACTION'
, 1
, 'FULL REDACTION'
, 2
, 'PARTIAL REDACTION'
, 3
, 'FORMAT PRESERVING REDACTION'
, 4
, 'RANDOM REDACTION'
, 5
, 'REGEXP REDACTION'
, 'UNSUPPORTED REDACTION') FUNCTION_TYPE
, RC.MPARAMS FUNCTION_PARAMETERS
, RC.REGEXP_PATTERN REGEXP_PATTERN
, RC.REGEXP_REPLACE_STRING REGEXP_REPLACE_STRING
, RC.REGEXP_POSITION REGEXP_POSITION
, RC.REGEXP_OCCURRENCE REGEXP_OCCURRENCE
, RC.REGEXP_MATCH_PARAMETER REGEXP_MATCH_PARAMETER
, RD.CDESC COLUMN_DESCRIPTION
FROM RADM$ R
, RADM_MC$ RC
, RADM_CD$ RD
, OBJ$ O
, USER$ U
, COL$ C
WHERE R.OBJ# = O.OBJ#
AND O.OWNER# = U.USER#
AND RC.INTCOL# = C.INTCOL#
AND RC.OBJ# = R.OBJ#
AND C.OBJ# = O.OBJ#
AND RC.OBJ# = RD.OBJ#(+)
AND RC.INTCOL# = RD.INTCOL#(+)