Home » RDBMS Server » Security » how to grant a percentage tablespace
how to grant a percentage tablespace [message #499137] Sun, 13 March 2011 17:30 Go to next message
most hacker
Messages: 15
Registered: October 2010
Location: Earth
Junior Member
Hi everybody !

Is it possible to grant a user a percentage amount of a specified tablespace ?

for instance granting a user called userx 5% of USERS tablespace. How can I do that ?

thanks alot;
Re: how to grant a percentage tablespace [message #499139 is a reply to message #499137] Sun, 13 March 2011 17:41 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
>Is it possible to grant a user a percentage amount of a specified tablespace ?
NO

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: how to grant a percentage tablespace [message #499190 is a reply to message #499137] Mon, 14 March 2011 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER USER ... QUOTA ... ON TABLESPACE ...

You cannot give a percentage, just a number of bytes.

Regards
Michel
Re: how to grant a percentage tablespace [message #499254 is a reply to message #499190] Mon, 14 March 2011 05:18 Go to previous message
most hacker
Messages: 15
Registered: October 2010
Location: Earth
Junior Member
Thank you very much guys
I'm sorry if I broke any rules in this form, but the reason I'm asking this beginner question is that I was told by an instructor in the college that I can grant a percentage quota besides setting an unlimited space and limited amount of bytes. Looks like his information need to be updated.
Previous Topic: Authenticating Oracle User based on Windows User Id
Next Topic: login Based on particular time
Goto Forum:
  


Current Time: Tue Oct 21 15:33:13 CDT 2014

Total time taken to generate the page: 0.11861 seconds