2.2.10 Ensure 'UTL_FILE_DIR' Is Empty

Information

The utl_file_dir setting allows packages like utl_file to access (read/write/modify/delete) files specified in utl_file_dir. This setting should have an empty value.

Note: The utl_file_dir parameter has been deprecated in 12.2 and higher versions.

Rationale:

Using the utl_file_dir to create directories allows the manipulation of files in these directories.

Solution

To remediate this setting, execute the following SQL statement.

ALTER SYSTEM SET UTL_FILE_DIR = '' SCOPE = SPFILE;

References:

http://docs.oracle.com/database/121/REFRN/GUID-DCA8A942-ACE1-46D6-876E-3244F390BCAE.htm#REFRN10230

See Also

https://workbench.cisecurity.org/files/2741