| 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
|
|
|
|
|
|
|
|
|
|
|
|
| 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
|
|
|
|
| Re: Quota Grant [message #642171 is a reply to message #642167] |
Fri, 04 September 2015 07:05 |
cookiemonster
Messages: 13963
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 #642178 is a reply to message #642122] |
Fri, 04 September 2015 09:04 |
John Watson
Messages: 8964
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
