Re: where are privileges?

Doug Cowles (dcowles_at_bigfoot.com) wrote:
: I've noticed that granting resource gives a user unlimited tablespace.
: Question is, how was I to know that? It's not in dba_sys_privs,
: role_sys_privs,
: role_role_privs etc., Is this something you have to just look up?

: - Dc.

From Oracle7 Server release 7.3 SQL Reference

UNLIMITED TABLESPACE ......... You cannot grant this system privilege to roles.

If you grant or revoke the RESOURCE or DBA role to or from a user, Oracle7 implicitly grants or revokes the UNLIMITED TABLESPACE system privilege to or from the user.

ie The privilege is granted directly to the user and does not

   show up under the RESOURCE role.

So, to see this privilege you need to query dba_sys_privs where grantee is the user to whom the RESOURCE role was given.

ie select privilege from dba_sys_privs where grantee='YOURUSER';

Hope this helps. Helen. Received on Wed May 19 1999 - 07:29:17 CDT