Sample Header Ad - 728x90

Revoking DBA Role From a User while it has also another having dba role in Oracle Database?

0 votes
2 answers
110 views
I have a very old user named "ADMINX" that has control in almost all tablespaces in an Oracle 19c database. It has been given "DBA" role and also a custom role named "APP_ADMIN_ROLE" that has DBA role inside. If i revoke DBA role from ADMINX itself but let APP_ADMIN_ROLE as it is, would tablespace quotas be reset? I suppose it should keep unlimited quotas since APP_ADMIN_ROLE still has DBA role within but i'm never sure how Oracle behaves in such cases. Sadly DBA_TS_QUOTAS doesn't show unlimited quotas taken by DBA roles.
Asked by postgresnewbie (127 rep)
Sep 6, 2024, 12:22 PM
Last activity: Sep 9, 2024, 11:29 AM