OraFAQ Forum: Enterprise Manager » default quota on tablespace for user

Home » RDBMS Server » Enterprise Manager » default quota on tablespace for user (oracle 9i , solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

default quota on tablespace for user [message #312679]

Wed, 09 April 2008 10:40

koff10
Messages: 58
Registered: December 2006
Location: france

Member

Hi All,

I'm using OEM 9i to create a user with default tablespace USERS without quota on this tablespace.
This new user have only connect GRANT.
When having a look on the quota for this user I notice that
it's none quota on this tablespace( of course) .

So My question is : NONE QUOTA means UNLIMITED QUOTA ?

thanks for Answer.
koff

Report message to a moderator

Re: default quota on tablespace for user [message #312686 is a reply to message #312679]

Wed, 09 April 2008 10:46

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Default quota is 0.
Now what does OEM display, I don't know.
"Those who live by the GUI, die by the GUI."

Query DBA_TS_QUOTAS to know how OEM handles this.

Regards
Michel

Report message to a moderator

Re: default quota on tablespace for user [message #312689 is a reply to message #312686]

Wed, 09 April 2008 10:49

harshnayak
Messages: 12
Registered: July 2007
Location: Los Angeles

Junior Member

By default, a user has no quota on any tablespace in the database. If the user has the privilege to create a schema object, you must assign a quota to allow the user to create objects. Minimally, assign users a quota for the default tablespace, and additional quotas for other tablespaces in which they can create objects.

Report message to a moderator