Step-by-Step: Create and Modify Oracle Directory Permissions

This content outlines the process for creating and managing directory permissions in Oracle Database. Users can create directories, grant or revoke read and write permissions, modify the directory path, and also drop directories as needed, ensuring proper access control within the database environment.

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;