you may not GRANT/REVOKE privileges to/from yourself
793919Oct 2 2010 — edited Oct 3 2010Hi ,
I created a user called as ravi . I created a procedure and ran it compiled successfully , but when i tried to run the procedure using execute , i got Invalid SQL Statement , the reason being invalid previliges .
When i tried to grant Priviliges from my user , i got *'you may not GRANT/REVOKE privileges to/from yourself'*
when googled for this , I found that The action to be taken as 'Issue the GRANT or REVOKE of system privileges from another database administrator account.'
please tell me how to resolve this .
Thanks in advance .