My Oracle Support Banner

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:

PL/SQL - Version and later
Information in this document applies to any platform.


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.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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