I downloaded the latest SQL Developer 126.96.36.199 version from OTN and am connected to a 188.8.131.52 database. When I try to create a data redaction policy, it throws an error stating "Grants missing on redaction_policies and redaction_columns." even though these privileges are granted to the user. This problem arises only from the GUI popup of add/alter redaction policy, but works when using the DBMS_REDACT.ADD_POLICY method. Anybody know how to fix this error ?
I believe you need to get these privileges assigned to you as the <user>
grant select on sys.redaction_policies to <user>;
grant select on sys.redaction_columns to <user>;