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);

Category: DatabaseSQL

Tags:

Leave a Reply

Article by: Shadab Mohammad