sqlplus connect <sys>/<pwd>
grant execute on utl_file to <user>
connect <user>/<pwd>
DESC utl_file
then i get:
ORA-24372: invalid object for describe
How can I access to UTL_FIL from other users in 11g xe? I already tried with public as well
Grant execute on utl_file to user in Oracle 11g XE
oracle-11goracle-11g-r2
Related Question
- Oracle’s UTL_FILE when connected locally or through listener has different behaviour
- Oracle – Resolving TNS Errors with Oracle Instant Client
- ORA-24033: No Recipient for Message Detected in Oracle
- Oracle – Error Granting SELECT on View Using ALL_OBJECTS
- Oracle UTLRP.SQL Execution Failure
- Error ORA-12505 when connecting to Database Oracle 11g SQL Developer
Best Answer
The grant worked just fine. You can't DESC a package or procedure, which is why you're getting an error.
Documentation for UTL_FILE is here. It provides sample PL/SQL that shows you how to use the package.
A short code snippet that sums up its functionality is here.