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