Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DBA tables access

i want to remove access from a user who has access to dba_* tables.

i tried the below and it does not work. any ideas?

revoke SELECT_CATALOG_ROLE, EXECUTE_CATALOG_ROLE, DELETE_CATALOG_ROLE, SELECT ANY DICTIONARY from xxxxx;

ERROR at line 1:

ORA-01952: system privileges not granted to xxxxx

Former Member
Not what you were looking for? View more on this topic or Ask a question