How To Lock a File After Creation When Using The UTL_FILE Package? (Doc ID 1476340.1)

Last updated on DECEMBER 13, 2022

Applies to:

Goal

The objective is to use UTL_FILE to write information to a file.

The goal is to have the privileges of that file limited to prevent others from accessing the file until the process is complete.

Although using umask will limit the privileges of the files created with UTL_FILE, unfortunately it will also limit the privileges for all files created by that user and not just UTL_FILE.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.