Oracle: How to list DBA users for a database

root's picture
SQL> [color=green]select name,open_mode from v$database;[/color]

NAME      OPEN_MODE
--------- ----------
GZDB      READ WRITE

SQL> [color=green]select * from dba_role_privs where grantee NOT LIKE '%SYS%' and grantee!='DBA';[/color]

GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
IMP_FULL_DATABASE              SELECT_CATALOG_ROLE            NO  YES
DBSNMP                         OEM_MONITOR                    NO  YES
XDB                            RESOURCE                       NO  YES
OLDIRP                         RESOURCE                       NO  YES
TIVOLI                         SELECT_CATALOG_ROLE            NO  YES

Thou shalt not steal!

If you want to use this information on your own website, please remember: by doing copy/paste entirely it is always stealing and you should be ashamed of yourself! Have at least the decency to create your own text and comments and run the commands on your own servers and provide your output, not what I did!

Or at least link back to this website.

Recent content