Friday, 28 March 2014

CREATE DIRECTORY IN ORACLE DATABASE GIVE READ WRITE PERMISSION

*** CREATE DIRECTORY IN ORACLE DATABASE ***
CREATE DIRECTORY :-
    WE ARE CREATE DIRECTORY IN ORACLE USING FOLLOWING SYNTAX.
SYNTAX : -
SQL> CREATE DIRECTORY <DIRECTORY_NAME> AS '<DIRECTORY_ABSOLUTE_PATH>';

*** PERMISSION ON DIRECTORY IN ORACLE ***
    give read permission to directory
Syntax :-
SQL> GRANT READ ON DIRECTORY <DIRECTORY_NAME> TO <USER_NAME>;

Example.
1. Create directory in oracle name as "EXAM_DIR" with path "d:\SANTOSH\oracle_dir", give read and write permission to user SANTOSH ?

Solution:
SQL> CREATE DIRECTORY EXAM_DIR AS 'D:\SANTOSH\oracle_dir';

Directory created.

SQL> GRANT READ, WRITE ON DIRECTORY EXAM_DIR TO SANTOSH;

No comments:

Post a Comment