Home » RDBMS Server » Security » system privilege
system privilege [message #273402] Wed, 10 October 2007 05:50 Go to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
Hi
i would like to ask you about how to allocate system privilege like "alter table table_name" to a new user.i tried

"grant alter table table_name to user"

but error "insufficient system privilege" is showing.I tried with sys administrator.But same error.But i can allocate alter any table privilege to user using oracle enterprise manager.But i have to allocate only one table access to this users.Any ideas?

many thanks
Ryju
Re: system privilege [message #273404 is a reply to message #273402] Wed, 10 October 2007 06:15 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
What do you want to do? Try:

SQL> grant all on <table_name> to <user>;
Re: system privilege [message #273409 is a reply to message #273402] Wed, 10 October 2007 06:23 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
I have to allow a user to insert some data into a table but not allowing to delete datas.So this should be apllied to only a specific table and specific users.I tried the above command and it worked.But i have to allow only insert coomand but not delete command to this user.How can i do that?
thanks
Ryju

[Updated on: Wed, 10 October 2007 06:28]

Report message to a moderator

Re: system privilege [message #273412 is a reply to message #273402] Wed, 10 October 2007 06:39 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

how to allocate system privilege like "alter table table_name" to a new user

SQL> grant alter on a to scott;

Grant succeeded.


Quote:

I have to allow a user to insert some data into a table but not allowing to delete datas.

SQL> grant insert on a to scott;

Grant succeeded.

Regards
Michel
Previous Topic: How to add conditions to user passwords
Next Topic: ORAPWD Utility
Goto Forum:
  


Current Time: Thu Mar 28 07:26:40 CDT 2024