RE: Find DBA users

[Farnsworth, Dave]

Title: Find DBA users

 select grantee from dba_role_privs where granted_role = 'DBA';

 

Dave

-----Original Message-----
From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 6:10 AM
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