3.17 Dropping an Oracle Data Redaction Policy

The DBMS_REDACT.DROP_POLICY procedure drops Oracle Data Redaction policies.

You can drop an Oracle Data Redaction policy whether it is enabled or disabled. You can find the names of existing Data Redaction policies, by querying the POLICY_NAME column of the REDACTION_POLICIES view. When you drop a table or view that is associated with an Oracle Data Redaction policy, the policy is automatically dropped. As a best practice, drop the policy first, and then drop the table or view afterward.

1. Connect to the PDB as a user who has the EXECUTE privilege on the DBMS_REDACT PL/SQL package and ADMINISTER REDACTION POLICY system or schema privilege.
2. Run the DBMS_REDACT.DROP_POLICY procedure.
   Use the following syntax:

   DBMS_REDACT.DROP_POLICY (
      object_schema       IN VARCHAR2 DEFAULT NULL, 
      object_name         IN VARCHAR2,
      policy_name         IN VARCHAR2);
   

   In this specification:

   • object_schema: Specifies the schema of the object to which the Data Redaction policy applies. If you omit this setting (or enter NULL), then Oracle Database uses the name of the current schema.

   • object_name: Specifies the name of the table or view to be used for the Data Redaction policy.

   • policy_name: Specifies the name of the policy to be dropped.

   For example:

   BEGIN
     DBMS_REDACT.DROP_POLICY (
       object_schema  => 'mavis',
       object_name    => 'cust_info',
       policy_name    => 'redact_cust_user_ids');
   END;
   /

After you run the DBMS_REDACT.DROP_POLICY procedure, the drop takes effect immediately.