Re: oracle and unix ownership/permissions

If your on Oracle 8, you could write an external procedure that calls a setuid script. Kind of a pain but You should be able to read the file.

In article <94ceqf$8ni$1_at_lure.pipex.net>,   "John Dunn" <JLDunn_at_ukgateway.net> wrote:
> 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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Sat Jan 20 2001 - 12:34:59 CST