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

From: Ram Srinivasan <srinivasanram2004_at_gmail.com>
Date: Thu, 12 Jan 2012 16:07:50 -0500
Message-ID: <CAKgSvf8YaRRdcrF-OjJ7qODvYB9Ky8usi7Vk6KP-idDum_U1pg_at_mail.gmail.com>

Here you go:
select grantee, GRANTED_ROLE from dba_role_privs where granted_role='DBA'
order by 1 ;

Ram Srinivasan

---

On Thu, Jan 12, 2012 at 3:44 PM, Stephane Faroult <sfaroult_at_roughsea.com>wrote:

> > 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
> >
>
> If I were you I would create my own view on top of sys.user$ and
> sys.sysauth$.
>
> --
> Stephane Faroult
> RoughSea Ltd <http://www.roughsea.com>
> Konagora <http://www.konagora.com>
> RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Sincerely
Ram Srinivasan


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

Received on Thu Jan 12 2012 - 15:07:50 CST