-
Hi there
I am trying to grant insert, update & delete object privileges to a table using the following command
GRANT INSERT, UPDATE, DELETE ON SYSADM.PS_ORD_TEST TO WEBROLE;
however I keep getting the error "ORA-01031: insufficient privileges"
I am performing the action using my own userid 'TONNERA', which has DBA rights, the tables belong to another user 'SYSADM'.
I have tried to alter my session to the tables schema, the alter works but I still get the error.
Any assistance would be great
Many thanks
Alison
-
you cannot grant privilege to another user objects that doesnt belong to you, even you are dba
-
I think that to grant object privileges to other users, only the owner can grant them.
Login as sysadm and then grant the privileges.
-
Many thanks for your information, I thought that this was the case, my senior DBA won't give me access to the SYSADM password...
I guess he will just have to do it himself.
Cheers
Allie
-
He might still decide to delegate this right to you, by isuing:
GRANT SELECT, INSERT DELETE, UPDATE ON sysadm.ps_ord_test TO alison WITH GRANT OPTION;
After that you will be able to grant those rights on that table to any other user, while your sysadm will keep enjoing his peace and tranquility
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|