Home » RDBMS Server » Server Administration » Quota Grant (Oracle 12c, windows 2012)
Quota Grant [message #642122] Thu, 03 September 2015 01:35 Go to next message
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
Re: Quota Grant [message #642123 is a reply to message #642122] Thu, 03 September 2015 01:47 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd say because Oracle said so.
Re: Quota Grant [message #642124 is a reply to message #642122] Thu, 03 September 2015 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Because a quota is not a privilege.

Re: Quota Grant [message #642126 is a reply to message #642124] Thu, 03 September 2015 02:48 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

Thanks, but in what category, it comes in.

Regards
Muktha
Re: Quota Grant [message #642127 is a reply to message #642126] Thu, 03 September 2015 03:23 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
A quota is a limit on the amount of resource one can use.
Re: Quota Grant [message #642167 is a reply to message #642127] Fri, 04 September 2015 05:44 Go to previous messageGo to next message
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
Re: Quota Grant [message #642171 is a reply to message #642167] Fri, 04 September 2015 07:05 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Quota Grant [message #642176 is a reply to message #642167] Fri, 04 September 2015 08:51 Go to previous messageGo to next message
gazzag
Messages: 1118
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
Re: Quota Grant [message #642178 is a reply to message #642122] Fri, 04 September 2015 09:04 Go to previous message
John Watson
Messages: 8922
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.
Previous Topic: PGA required for optimal and one-pass execution
Next Topic: Archive Logs are filling fast
Goto Forum:
  


Current Time: Thu Mar 28 04:55:16 CDT 2024