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!

PLSQL - How to generate a text file with all permission using UTL_FILE

4004953May 23 2019 — edited May 23 2019

Dear all,

How to generate a text file will all permission using UTL_FILE in PLSQL.

My issues is that my generated file does not have all the permission.

Please find below screenshot:

pastedImage_1.png

The following command already executed:

CREATE OR REPLACE DIRECTORY MCB_WORKERS_DIR AS '/workers';

GRANT READ,WRITE,EXECUTE ON DIRECTORY MCB_WORKERS_DIR TO APPS

Thanks

Comments
Post Details
Added on May 23 2019
5 comments
2,076 views