Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

you may not GRANT/REVOKE privileges to/from yourself

793919Oct 2 2010 — edited Oct 3 2010
Hi ,



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 .
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2010
Added on Oct 2 2010
4 comments
1,115 views