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
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.
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
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width