Re: How to identify who is the schema with DBA privilege
- From: Ram Srinivasan <srinivasanram2004@xxxxxxxxx>
- To: sfaroult@xxxxxxxxxxxx
- Date: Thu, 12 Jan 2012 16:07:50 -0500
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@xxxxxxxxxxxx>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>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Sincerely
Ram Srinivasan
--
//www.freelists.org/webpage/oracle-l
Other related posts:
