Oracle DB如何知道在文件系统中写入文件时要使用哪个用户帐户 [英] How Oracle DB knows which user account to use when it writes a file in a filesystem

问题描述

在哪里设置？

谢谢

解决方案

Oracle进程以用户身份运行 - 通常 oracle - 它创建的文件将由该用户及其默认组拥有，例如 oracle：dba 。

无论如何，在UNIX / Linux类型的系统上。这就是所有程序默认情况下的工作原理 - 您需要努力以不同的用户身份创建文件（真实与有效的用户ID等）。一个文件所属的组稍微复杂一些，因为这可能会受到目录权限的影响。

这在文档的各个地方都有提到，例如 for UTL_FILE ：

在UNIX系统上，由FOPEN函数创建的文件的所有者是运行该实例的影子进程的所有者。通常，这个所有者是ORACLE。使用FOPEN创建的文件总是可写和可读的使用UTL_FILE子程序。但是，需要在PL / SQL之外读取这些文件的非特权操作系统用户可能需要系统管理员的访问权。

How Oracle DB knows which user account to use when it writes a file in a filesystem.

Where this is set up?

Thank you

解决方案

The Oracle processes are running as a user - usually oracle - and files it creates will be owned by that user and its default group, e.g. oracle:dba.

On UNIX/Linux-type systems anyway. That's how all programs work by default - you need to make some effort to create files as a different user (real vs. effective user ID etc.). The group a file belongs to is slightly more complicated as that can be affected by the directory permissions.

This is mentioned in various places in the documentation, for example for UTL_FILE:

On UNIX systems, the owner of a file created by the FOPEN function is the owner of the shadow process running the instance. Normally, this owner is ORACLE. Files created using FOPEN are always writable and readable using the UTL_FILE subprograms. However, non-privileged operating system users who need to read these files outside of PL/SQL may need access from a system administrator.

这篇关于Oracle DB如何知道在文件系统中写入文件时要使用哪个用户帐户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！