InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is A Directory Object? |
|
Answer» A 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/fyicenter 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.A 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: |
|