Apparently the way to do this is to set up a seperate external procedure
listener to run as the appropriate user.
Unfortunately utl_file still seems to run as oracle
John
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 14, 2001 10:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:RE: change unix user when running external procedure
>
> John,
>
> Sorry, I wasn't sure it would work either. Can you change the
> permissions
> on the file to be read to public read access?
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: John Dunn <[EMAIL PROTECTED]>
> Date: 3/14/2001 1:25 AM
>
> Dick....I tried this but it didn't work...
>
> When I write a file using my shared libary the ownership is still oracle,
> not john
>
>
> -rwsrwxrwx 1 john john myClib.so
>
> -rw-rw-r-- 1 oracle dba testfile
>
> John
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 13, 2001 10:01 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re:change unix user when running external procedure
> >
> >
> > John,
> >
> > I'm not totally sure this will work, but it's worth a try.
> >
> > Create the shared library file (.so in Unix land) as the owner of the
> file
> > that
> > needs to be read. Then set the suid bit on the .so file. Make sure
> there
> > is
> > execute priviledges to public as well I thins it's "chmod 755". When
> the
> > external procedure is called it should launch under the original owner's
> > account/permissions.
> >
> > Dick Goulet
> > ____________________Reply Separator____________________
> > Author: John Dunn <[EMAIL PROTECTED]>
> > Date: 3/13/2001 9:11 AM
> >
> > I am running an external C procedure. The C function needs to access
> > afile...but it is not owned by oracle and is read only for the user that
> > does own it.
> >
> > Is there anyway that I can access this file? External procedures always
> > seem
> > to run as oracle.
> >
> > John
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: John Dunn
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
