From dgoulet@vicr.com Wed, 14 Mar 2001 14:45:59 -0800 From: dgoulet@vicr.com Date: Wed, 14 Mar 2001 14:45:59 -0800 Subject: Re:RE: change unix user when running external procedure Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 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: dgoulet@vicr.com [SMTP:dgoulet@vicr.com] > 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 > 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: john.dunn@sefas.co.uk > > 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: ListGuru@fatcity.com (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: dgoulet@vicr.com > > 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: ListGuru@fatcity.com (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: john.dunn@sefas.co.uk 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: ListGuru@fatcity.com (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: dgoulet@vicr.com 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: ListGuru@fatcity.com (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).