Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Grant READ,WRITE access

862489Aug 3 2011 — edited Aug 3 2011
I am creating a directory as LIVE_OWNER user after the DBA grants CREATE ANY DIRECTORY privilege to LIVE_OWNER User


SQL>CREATE DIRECTORY LIVEDIR AS '/batch/loc/tmp';

Should I give the below grant query after I log in as LIVE_OWNER or no need of giving grants as the CREATOR has privileges to READ/WRITE

Pls suggest me

SQL>GRANT read, write ON DIRECTORY LIVEDIR TO LIVE_OWNER

Thanks for ur help in advance

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 31 2011
Added on Aug 3 2011
#access
3 comments
138,217 views