Re: oracle and unix ownership/permissions

Responses embedded.

In our last gripping episode "John Dunn" <JLDunn_at_ukgateway.net> wrote:
> Aarrghhhh!
>
> Do Oracle processes always run as the oracle user?
>

Yes.

> I need to read a file via utl_file that is owned by another user and
 is
> read only to that user, i.e 400 permissions.
>
> This is the way the Unix system admin is set up. Unix systems admin
 has
> assigned a user and directories for me to use and this file can only
 be read
> only for that user.How can I get Oracle to read it....can I change
 the user
> that oracle runs as to run as an application user?
>

No, but the permissions can be changed on that file by the owner (or, as you state, the user). A simple 'chmod 644 <filename>' should suffice and allow Oracle to read the flat file. Additionally the directory where that file resides will also need to be open to the rest of the UNIX 'world'; 'chmod 755 <directoryname>' will correct that; if the directory is the user's home directory then, as that user, a 'chmod 755 $HOME' will change the permissions, presuming, of course, that the UNIX admins did their job properly and gave the user ownership of his or her directories.

> John
>
>

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/