Create & grant permission to directory in Oracle

Create, grant permission, modify, drop database directory in Oracle

Create directory in Oracle Database Create directory dir_name as 'D:\scripts';

Grant read write permission to Directory: --grant read permission GRANT read on DIRECTORY dir_name to user_name; --grant write permission GRANT write on DIRECTORY dir_name to user_name; -- grant both GRANT READ,WRITE ON DIRECTORY dir_Name TO user_Name;