| Default Quota size [message #171334] |
Tue, 09 May 2006 07:51  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
I created a user without assinging any quota & the user can create objects. The activities i did are given below(I'm using ORACLE 9i),
SQL> create user hir identified by hir
2 default tablespace HIREDATATBS
3 temporary tablespace temp;
User created.
SQL> create table emp(id number);
Table created.
SQL> insert into emp values(1);
1 row created.
Now,clear my doubts,
1) Is it possible to create objects without having quota on default tablespace?
2) If it's so,then what is the need of assigning QUOTA?
3) What is the default quota size for the user on default tablepsace?
Thanks,
Gajini
|
|
|
|
| Re: Default Quota size [message #171339 is a reply to message #171334] |
Tue, 09 May 2006 07:56  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
You created user HIR.
You created the tables logged in as the original user. NOT as HIR.
>> 1) Is it possible to create objects without having quota on default tablespace?
Yes. If the resource role is granted to user, he get unlimited quota. That answers the rest of the questions.
[Updated on: Tue, 09 May 2006 07:56] Report message to a moderator |
|
|
|
| Re: Default Quota size [message #171342 is a reply to message #171334] |
Tue, 09 May 2006 08:01 |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Have you granted the RESOURCE role to that user? If so, Oracle implicitly granted UNLIMITED TABLESPACE to it. TO check:
select * from session_privs where PRIVILEGE = 'UNLIMITED TABLESPACE'; |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
