181. QUESTION 15
In your www.data-lab.org production database, you find that the database users are able to create and read files with unstructured data, available in any location on the host machine from an application.
You want to restrict the database users to access files in a specific location on the host machine.
What could do to achieve this?
A> Modify the value for the UTL_FILE_DIR parameter in the parameter file
B> Grant read and write privilege on the operating system path to the database users
C> Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file
D> Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file
E> Create a directory object referring to the
Answer: A
UTL_FILE_DIR
Property | Description |
---|---|
Parameter type | String |
Syntax | UTL_FILE_DIR = pathname |
Default value | There is no default value. |
Modifiable | No |
Range of values | Any valid directory path |
UTL_FILE_DIR
lets you specify one or more directories that Oracle should use for PL/SQL file I/O. If you are specifying multiple directories, you must repeat theUTL_FILE_DIR
parameter for each directory on separate lines of the initialization parameter file.
All users can read or write to all files specified by this parameter. Therefore all PL/SQL users must be trusted with the information in the directories specified by this parameter.
Note:
If you list multiple values, all entries of this parameter must be on contiguous lines of the parameter file. If you separate them with other parameters, Oracle will read only the last (contiguous) lines.