Oracle Error Message
ORA-28081: Insufficient privileges – the command references a redacted object.
Reason for the Error
The command referenced a redacted column in an object protected by a data redaction policy.
Solution
If possible, modify the command to avoid referencing any redacted columns. Otherwise, drop the data redaction policies that protect the referenced tables and views, or ensure that the user issuing the command has the EXEMPT REDACTION POLICY system privilege, then retry the operation. 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. The EXEMPT REDACTION POLICY system privilege is required for performing a data pump schema-level export including any object protected by a data redaction policy. All data redaction policies are listed in the REDACTION_COLUMNS catalog view.
