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;


Revoke permission from directory

-- revoke read permission
REVOKE read on DIRECTORY dir_name FROM User_Name;
-- revoke write permission
REVOKE write on DIRECTORY dir_name FROM User_Name;
-- revoke both
REVOKE read,write on Directory dir_name from user_name;


Modify path of directory

SQL> create or replace directory dbscript as 'D:\';
Directory created.
SQL> create or replace directory dbscript as 'D:\scripts';
Directory created.


Drop the directory

DROP Directory dbscript;