DBA Hub

📋Steps in this guide1/1

Drop a redaction policy

-- Find the policy details

oracle configurationintermediate
by OracleDba
13 views
1

Drop a redaction policy

-- Find the policy details -- Drop the policy

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
SELECT OBJECT_OWNER,OBJECT_NAME,POLICY_NAME FROM REDACTION_POLICIES ;
BEGIN
DBMS_REDACT.drop_policy (
object_schema => 'SCOTT',
object_name => 'CREDIT_CARD_TAB',
policy_name => 'CREDIT_HIDE_POLICY'
);
END;
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!