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;

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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/

Report message to a moderator

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: 68641
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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Authenticating Oracle User based on Windows User Id
Next Topic: login Based on particular time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 05:08:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.