Re: Privs of RESOURCE role not showing up

Jerome Vitalis wrote:
> This is 9.2.0.7.0 on Windows :
>
> select privilege from dba_sys_privs where grantee='RESOURCE'
>
> PRIVILEGE
> ----------------------------------------
> CREATE TYPE
> CREATE TABLE
> CREATE CLUSTER
> CREATE TRIGGER
> CREATE OPERATOR
> CREATE SEQUENCE
> CREATE INDEXTYPE
> CREATE PROCEDURE
>
> 8 rows selected
>
>
> select privilege from role_sys_privs where role='RESOURCE'
>
> PRIVILEGE
> ----------------------------------------
>
> 0 rows selected
>
>
> 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?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown