What Is a Directory Object?
Submitted by: AdministratorA directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good examples:
>sqlplus /nolog
SQL> connect SYSTEM/globalguideline
SQL> CREATE DIRECTORY test_dir AS '/oraclexe/test';
Directory created.
SQL> GRANT READ ON DIRECTORY test_dir TO hr;
Grant succeeded.
SQL> GRANT WRITE ON DIRECTORY test_dir TO hr;
Grant succeeded.
SQL> CREATE DIRECTORY temp_dir AS '/oraclexe/temp';
Directory created.
SQL> DROP DIRECTORY temp_dir;
Directory dropped.
Submitted by: Administrator
>sqlplus /nolog
SQL> connect SYSTEM/globalguideline
SQL> CREATE DIRECTORY test_dir AS '/oraclexe/test';
Directory created.
SQL> GRANT READ ON DIRECTORY test_dir TO hr;
Grant succeeded.
SQL> GRANT WRITE ON DIRECTORY test_dir TO hr;
Grant succeeded.
SQL> CREATE DIRECTORY temp_dir AS '/oraclexe/temp';
Directory created.
SQL> DROP DIRECTORY temp_dir;
Directory dropped.
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | How Much Memory Your 10g XE Server Is Using? |
☺ | How Run SQL*Plus Commands That Are Stored in a Local File? |
☺ | How To Run SQL*Plus Commands in SQL Developer? |
☺ | What Is the Relation of a User Account and a Schema? |
☺ | How To Check Your Oracle Database 10g XE Installation? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |