Skip to Main Content

Oracle Database Discussions

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!

Unable to grant UTL_FILE to another user

RainbowwsSep 1 2015 — edited Sep 2 2015

Hi All,

I just hit an issue on granting privilege and would like to seek some help

I have creates a new user e.g. FPSYS

I have grant a bunch of privileges to FPSYS including this:

     grant execute on UTL_FILE to FPSYS with grant option;

I then login as FPSYS and attempt to grant UTL_FILE to someone else:

   grant execute on UTL_FILE TO USERA;

However I hit ORA-01031: insufficient privileges

My FPSYS already has UTF_FILE with grant option from SYS, he should be able to grant this to other user...?

I am using Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

Any help appreciated

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2015
Added on Sep 1 2015
9 comments
1,587 views