RE: Find DBA users

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Mon, 26 Nov 2001 06:56:11 -0800
Message-ID: <F001.003CCB27.20011126054526@fatcity.com>

SYSTEM_at_ORANS.QTEL.COM.QA> select grantee from dba_role_privs where granted_role='DBA';

GRANTEE

---

SCOTT
SYS
SYSTEM SYSTEM_at_ORANS.QTEL.COM.QA> grant dba to nirmal;

Grant succeeded.

SYSTEM_at_ORANS.QTEL.COM.QA> select grantee from dba_role_privs where granted_role='DBA';

GRANTEE

---

NIRMAL
SCOTT
SYS
SYSTEM SYSTEM_at_ORANS.QTEL.COM.QA> HTH, Nirmal.

-----Original Message-----

From:   Daiminger, Helmut [SMTP:Helmut.Daiminger_at_KirchGruppe.de]
Sent:   Monday, November 26, 2001 3:10 PM
To:     Multiple recipients of list ORACLE-L

Subject:        Find DBA users

Hi!

Is there a data dictionary view that gives me all users who have geen granted the DBA role?

This is 8.1.7 on Sun Solaris.

Thanks,
Helmut Received on Mon Nov 26 2001 - 08:56:11 CST