Re: oracle and unix ownership/permissions

david

Thanks....but the file I want to read must remain 400 permissions according to the System admin standards...and will not be owned by Oracle....

John

David Fitzjarrell <oratune_at_aol.com> wrote in message news:94ae64$8ie$1_at_nnrp1.deja.com...
> 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/
Received on Sat Jan 20 2001 - 10:40:35 CST