you can do this all easily with a java stored procedure. alot less code. also, it will run as the DBA group on unix. there is an example in tom kytes book. Really short code. You can call any OS script with it. Might be on his website too.
you then create a chmod script in unix that oracle has permissions to execute. That script will have permission to effect the users script. Sound abstraction. Then Oracle can only effect the users script through your intermediary. > > From: "Henry Poras" <[EMAIL PROTECTED]> > Date: 2003/09/05 Fri PM 04:29:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: external procedure as not-oracle on OS > > In order to run some OS commands from within the database we have set up a > few external procedures. One of the functions we need to accomplish is to > change the permissions of a file owned by a user other than oracle. As the > external procedure is executed by Oracle, this is a problem. I tried > changing the ownership of the .so file to the other user, setting the setuid > bit, and granting oracle execute permissions on this file. That didn't work. > Our next thought is to have the .so file call a C executable (set with the > setuid bit) which will run chmod. The thought of one person here is that > setuid is strictly for executables and .so is more of a > library/collection-of-code, not strictly an exe. I'm not too clear on this > differentiation. It's also an ugly solution, but that's the direction in > which we are moving. > > Has anyone come up with any other alternatives? > > Thanks. > > Henry > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Henry Poras > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
