My Oracle Support Banner

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

Last updated on MARCH 12, 2021

Applies to:

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

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

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
Goal
Solution


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