How to identify who is the schema with DBA privilege

From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 12 Jan 2012 18:39:24 -0200

Hi,
I would like to know how to identify who has DBA privilege.

If I do : SELECT * FROM user_ROLE_PRIVS

I can see my privileges.

There is no ALL_ROLE_PRIVS and DBA_ROLE_PRIVS .

Is there another view or table that can say it to me ?

Note: I need to know in both situations:

         With DBA schema connected and not DBA schema connected.

Regards
Eriovaldo


--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: How to identify who is the schema with DBA privilege
From: Stephane Faroult

How to identify who is the schema with DBA privilege

Other related posts: