| unlimited tablespace [message #60645] |
Mon, 23 February 2004 20:24  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
hi all, unlimited tablespace is the privilege which is assigned to the user when i assign the "RESOURCE" role. but it doesnt turn up when i query for the privileges under this role using dba_role_privs or dba_sys_privs or dba_role_roles.
can anybody tell me whi is it not showing?
thanx in advance.
|
|
|
|
| Re: unlimited tablespace [message #60656 is a reply to message #60645] |
Tue, 24 February 2004 04:31  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Hi,
When you grant RESOURCE role to a user, the user is implicitly granted unlimited tablespace privilege. It doesnt show up in the data dictionary that the RESOURCE role 'has' unlimited tablespace privilige . Infact 'unlimited tablespace' privilege cannot be granted to a role and RESOURCE is a role. Its an implicit privilege.
SQL> grant unlimited tablespace to test_role;
grant unlimited tablespace to test_role
*
ERROR at line 1:
ORA-01931: cannot grant UNLIMITED TABLESPACE to a role
SQL> !oerr ora 1931
01931, 00000, "cannot grant %s to a role"
// *Cause: UNLIMITED TABLESPACE, REFERENCES, INDEX, SYSDBA or SYSOPER
// privilege cannot be granted to a role.
// *Action: Grant privilege directly to the user.
SQL> grant unlimited tablespace to test;
Grant succeeded.
SQL> select * from dba_sys_privs where grantee='TEST';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TEST CREATE SESSION NO
TEST UNLIMITED TABLESPACE
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
