Database Oracle

List users with DBA role

If you need to see which users have given the DBA role, here’s a simple query to do it:

SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTED_ROLE = 'DBA';