Create & grant permission to directory in Oracle
Create directory in Oracle Database
SQL> Create directory dir_name as 'D:dumps';
Grant read write permission to Directory:
--grant read permission SQL> GRANT read on DIRECTORY dir_name to user_name; --grant write permission SQL> GRANT write on DIRECTORY dir_name to user_name; -- grant both SQL> GRANT READ,WRITE ON DIRECTORY dir_Name TO user_Name;
Revoke permission from directory
-- revoke read permission SQL> REVOKE read on DIRECTORY dir_name FROM User_Name; -- revoke write permission SQL> REVOKE write on DIRECTORY dir_name FROM User_Name; -- revoke both SQL> REVOKE read,write on Directory dir_name from user_name;
Modify path of directory
SQL> create or replace directory dir_name as 'D:'; Directory created. SQL> create or replace directory dir_name as 'D:scripts'; Directory created.
Drop the directory
SQL> DROP Directory dir_name;
Similar Posts:
- How to Enable / Disable Restricted Session in Oracle Database
- ORA-01113: file n needs media recovery – ORA-01110: data file n: \SYSTEM01.dbf′
- How to create Dblink between Oracle & PostgreSQL
- 15 Oracle Exp Command Examples to Export Database Objects
- ORA-00020 maximum number of processes exceeded
2,632