Check users with dba privilege

SELECT /*+ RULE */ GRANTEE
FROM SYS.DBA_ROLE_PRIVS A
WHERE GRANTED_ROLE=’DBA’
AND EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME =A.GRANTEE);

Leave a Reply