Re: How to identify who is the schema with DBA privilege
From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Thu, 12 Jan 2012 21:44:53 +0100
Message-ID: <4F0F4645.2070901_at_roughsea.com>
> 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
>
Date: Thu, 12 Jan 2012 21:44:53 +0100
Message-ID: <4F0F4645.2070901_at_roughsea.com>
> 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-lReceived on Thu Jan 12 2012 - 14:44:53 CST