Oracle Redaction commands

to check the redacted columns
--------------------------------------------------------------
select * from redaction_columns;

to check the redaction policies
--------------------------------------------------------------
select * from redaction_policies;



enable a policy
----------------------------------------------------------------
BEGIN
  SYS.dbms_redact.enable_policy (
   object_schema => 'SCHEMA_NAME',
    object_name   => 'T__MEMBER',
    policy_name   => 'T__MEMBER_REDACT'  
    );
END;
/

disable a policy
----------------------------------------------------------------
BEGIN
  SYS.dbms_redact.disable_policy (
   object_schema => 'SCHEMA_NAME',
    object_name   => 'T__MEMBER',
    policy_name   => 'T__MEMBER_REDACT'  
    );
END;
/


add a column to policy
-----------------------------------------------------------------
BEGIN
  DBMS_REDACT.alter_policy (
   object_schema => 'SCHEMA_NAME',
    object_name   => 'T__ADDRESS',
    policy_name   => 'T__ADDRESS_REDACT',
    action        => DBMS_REDACT.add_column,
    column_name   => 'ZIP',
 function_type => DBMS_REDACT.full
    );
END;
/


drop a column from policy
------------------------------------------------------------------
BEGIN
  DBMS_REDACT.alter_policy (
   object_schema => 'SCHEMA_NAME',
    object_name   => 'T__MEMBER',
    policy_name   => 'T__MEMBER_REDACT',
    action        => DBMS_REDACT.drop_column,
    column_name   => 'LAST_NAME',
 function_type => DBMS_REDACT.full
    );
END;
/