Tablespace Quota

A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA
- Default Tablespace Quota 500 M
- Tablespace 1 Quota 100 M
- Tablespace 2 Quota 200 M
Now the user tries to make a table which uses 300 M in tablespace 2. Will he be successful?

Questions by shanthiavari

Showing Answers 1 - 4 of 4 Answers

vishnusivathej

  • Jul 21st, 2008
 

i dont think there will be any error instead the user has resource privilege which gives  unlimited access to tablespaces.. here resource privilege takes precedence..

  Was this answer useful?  Yes

vishnusivathej

  • Jul 21st, 2008
 

there will be no such thing as default size for a tablespace u have to assign it when it is being created..
and more over by default u can have 100 datafiles in a database which is the default value used during the database creation process u can also change this value..

  Was this answer useful?  Yes

bassem_farouk

  • Sep 17th, 2008
 

Yes he will be successful. because resource role grant user unlimited tablespace system privilege. quota ignored.
SQL> create user test identified by test1;
User created.
SQL> grant connect, resource to test;
Grant succeeded.
SQL> select * from dba_sys_privs where grantee='TEST'
GRANTEE PRIVILEGE ADMIN_
---------- -------------------- ------
TEST UNLIMITED TABLESPACE NO

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions