OCI-28081
Insufficient privileges. The command references a redacted object.
Cause
The command referenced a redacted column in an object protected by a data redaction policy.
Action
Do one of the following and then retry the operation:
- Modify the command to avoid referencing any redacted columns.
- Drop the data redaction policies that protect the referenced tables and views.
- Ensure that the user issuing the command has the EXEMPT REDACTION POLICY system privilege.
The EXEMPT REDACTION POLICY system privilege is required for:
- Creating or refreshing a materialized view when the materialized view is based on an object protected by a data redaction policy.
- Performing a data pump schema-level export including any object protected by a data redaction policy.
- DML or DDL operations if a column with data redaction policy appears as the source.
- Creating mining models on tables that have a column with data redaction policy as internally Oracle Data Mining issues DDL and DML statements.
All data redaction policies are listed in the REDACTION_COLUMNS catalog view.