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
Last activity: Sep 9, 2024, 11:29 AM