[EMAIL PROTECTED]> select grantee from dba_role_privs where granted_role='DBA';
GRANTEE
------------------------------
SCOTT
SYS
SYSTEM
[EMAIL PROTECTED]> grant dba to nirmal;
Grant succeeded.
[EMAIL PROTECTED]> select grantee from dba_role_privs where granted_role='DBA';
GRANTEE
------------------------------
NIRMAL
SCOTT
SYS
SYSTEM
[EMAIL PROTECTED]>
HTH,
Nirmal.
-----Original Message-----
From: Daiminger, Helmut [SMTP:[EMAIL PROTECTED]]
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
