*** 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;
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