Hi currently I am working on Oracle Data Redaction with data redact to full type.
I had configured what all the prerequisites required for that like.
Login to sysdba-
GRANT EXECUTE ON sys.dbms_redact TO PCD_ATOMIC; //Here PCD_ATOMIC is the atomic schema name.
Now after login to schema i have a table called
payment_details in this table column is card_no and I executed this query
BEGIN
DBMS_REDACT.add_policy(
object_schema => 'PCD_ATOMIC',
object_name => 'payment_details',
column_name => 'card_no',
policy_name => 'sam_test_redact_card_info',
function_type => DBMS_REDACT.full,
expression => '1=1'
);
END;
/
But after running this the Data is not redacted.
So need someone who can help me in this.
Might be i had done some configuration mistakes but need help in this to fix this issue.