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:Click to share on Twitter (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on WhatsApp (Opens in new window) Category: Database • SQL Tags: 10g • 11g • 11gR2 • oracle • SQL