Reverting the Data Redaction for an individual Column

To revert the data redaction for an individual column:

1. Run the below query as a SYS user.
   select * from REDACTION_POLICIES t where t.object_name='##TABLE_NAME##';
2. Fetch the policy name from the table.
3. Update the below procedure and run in the atomic schema.

   
   begin
       dbms_redact.ALTER_POLICY ( 
           object_schema => '##USER_NAME##',
           object_name => '##TABLE_NAME##',
           policy_name => '##POLICY_NAME##',
       action => dbms_redact.drop_column,
           column_name => '##COULMN_NAME##'
       );
   end;
   /