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