OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Quota Grant (Oracle 12c, windows 2012)

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

Quota Grant [message #642122]

Thu, 03 September 2015 01:35

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Hope all is well,

I have a small doubt on Tablespace Quota.

We do assign Quota on TBS by ALTER USER xyz QUOTA UNLIMITED ON <name>;
Why we cant do the same with GRANT QUOTA UNLMITED... method.

Regards
Muktha

Report message to a moderator

Re: Quota Grant [message #642123 is a reply to message #642122]

Thu, 03 September 2015 01:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'd say because Oracle said so.

Report message to a moderator

Re: Quota Grant [message #642124 is a reply to message #642122]

Thu, 03 September 2015 01:49

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

Senior Member
Account Moderator

Because a quota is not a privilege.

Report message to a moderator

Re: Quota Grant [message #642126 is a reply to message #642124]

Thu, 03 September 2015 02:48

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Thanks, but in what category, it comes in.

Regards
Muktha

Report message to a moderator

Re: Quota Grant [message #642127 is a reply to message #642126]

Thu, 03 September 2015 03:23

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

A quota is a limit on the amount of resource one can use.

Report message to a moderator

Re: Quota Grant [message #642167 is a reply to message #642127]

Fri, 04 September 2015 05:44

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Gazzag,

Thanks, but How can we are able to grant privs like 'GRANT UNLMITED TABLESPACE TO <user>.
What is the diff.

Thanks
Muktha

Report message to a moderator

Re: Quota Grant [message #642171 is a reply to message #642167]

Fri, 04 September 2015 07:05

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

The difference is that oracle decided it should be that way. This really isn't something worth worrying about and you're unlikely to get a definitive answer.

Report message to a moderator

Re: Quota Grant [message #642176 is a reply to message #642167]

Fri, 04 September 2015 08:51

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

If I had to guess, "UNLIMITED TABLESPACE" sounds more like a privilege than a limit/quota. But as cookiemonster says, I doubt it is worth worrying about Smile

Report message to a moderator

Re: Quota Grant [message #642178 is a reply to message #642122]

Fri, 04 September 2015 09:04

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

It's just an historical anomaly. Back in release 5 (if I remember correctly) there was only CONNECT for the users; RESOURCE for the developers; and DBA for us. So you gave the developers a quota.
Then the ANSI/ISO syntax for GRANT and REVOKE of privileges came along. There's no ISO syntax for assigning a quota.

Report message to a moderator

Previous Topic:	PGA required for optimal and one-pass execution
Next Topic:	Archive Logs are filling fast

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 05:58:32 CDT 2025