| system privilege [message #273402] |
Wed, 10 October 2007 05:50  |
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 #273409 is a reply to message #273402] |
Wed, 10 October 2007 06:23  |
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 |
 |
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
