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!

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
3 comments
138,792 views