Check users with dba privilege By Shadab Mohammad • Apr 4, 2012 • No comments SELECT /*+ RULE */ GRANTEE FROM SYS.DBA_ROLE_PRIVS A WHERE GRANTED_ROLE=’DBA’ AND EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME =A.GRANTEE); Share this: Share on X (Opens in new window) X Share on LinkedIn (Opens in new window) LinkedIn Share on Facebook (Opens in new window) Facebook Share on Tumblr (Opens in new window) Tumblr Share on WhatsApp (Opens in new window) WhatsApp Category: Database • SQL Tags: 10g • 11g • 11gR2 • oracle • SQL