Re: Privs of RESOURCE role not showing up

From: Jerome Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Fri, 01 Dec 2006 11:14:38 +0100
Message-ID: <456fffa4$0$25425$426a74cc@news.free.fr>

Brian Peasland wrote:
> Jerome Vitalis wrote:

>> Why don't these privileges show up in the role_ view?
>>
>> TIA

>
> Gotta love the documentation:
>
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4232.htm#sthref2882
>
>
> "Information is provided only about roles to which the user has access"
> Have you been granted the RESOURCE role?
>

Now I love the documentation ;-)
You guessed correctly: the user I was connected with is not granted the RESOURCE role, "only" the DBA role.

Thanks Brian! Received on Fri Dec 01 2006 - 04:14:38 CST