Re: How to identify who is the schema with DBA privilege
- From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- Date: Fri, 13 Jan 2012 22:03:52 -0200
Hi friends,
Thanks a lot for answers.
The issue is solved.
Regards
Eriovaldo
On Thu, Jan 12, 2012 at 10:15 PM, Guillermo Alan Bort
<cicciuxdba@xxxxxxxxx>wrote:
> If you can't see DBA_ROLE_PRIVS (getting ora-942) you probably don't have
> select privileges on it, because the view does exist. If querying dba_views
> doesn't show it, then you probably need to run the catalog scripts... but
> I'd open a SR with MOS in that case.
> Alan.-
>
>
> On Thu, Jan 12, 2012 at 6:18 PM, Niall Litchfield <
> niall.litchfield@xxxxxxxxx> wrote:
>
>> You'll want a recursive version, but Pete Finnigan already has one,
>> http://www.petefinnigan.com/weblog/archives/00001243.htm
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
