This content has been marked as final. Show 5 replies
please explain in detail what you want ????????????
You grant read or write on a directory created with create directory.
Or you grant execute on a function/procedure/package.
utl_file is a package, so you may only grant execute on that.
--removed content as already answered.
Edited by: ragu.dba.in on Apr 2, 2013 1:11 AM
995017 wrote:Your subject i s- Re: How to grant priv in DBA_TAB_PRIVS
I logged in as system and I just execute below script, however Im getting error "SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist""
GRANT execute ON UTL_FILE TO USER1;
How to grant privilege on ult_file?
Edited by: 995017 on Apr 2, 2013 1:08 AM
Edited by: 995017 on Apr 2, 2013 1:14 AM
But your message part talks about - GRANT execute ON UTL_FILE TO USER1;
What is your exact issue?
Connect as SYS user and execute the same script. It shall work.1 person found this helpful