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
Oracle: How to list DBA users for a database
Submitted by root on