oracle 如何更改使用 UTL_FILE.FOPEN 创建的文件的权限?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/10994647/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 00:53:34  来源:igfitidea点击:

How to change permission of a file created using UTL_FILE.FOPEN?

sqloraclefile-permissions

提问by Nitish

I have an oracle procedure which creates a text file using the UTL_FILE.FOPEN function. The file is created with permission 660. How can I change the permission of the file without using chmod?(I don't have access to the server)

我有一个使用 UTL_FILE.FOPEN 函数创建文本文件的 oracle 过程。文件是用权限660创建的。如何不使用chmod更改文件的权限?(我没有访问服务器的权限)

回答by Frank Schmitt

You could change the umask of the Unix user that owns the Oracle process (resp. ask the system administrator to perform this task for your), see

您可以更改拥有 Oracle 进程的 Unix 用户的 umask(分别要求系统管理员为您执行此任务),请参阅

UTL_FILE permissions

UTL_FILE 权限