On Fri, 16 Mar 2001, John Dunn wrote:
> 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
John,
If you are having problems with access to files created by
Oracle v
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
DickI 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]]
>
Dick...thanks...I''ll give it a go.
I have a similar problem with utl_file command in PL/SQL accessing a file
that is read only for another user. I can't see any way of accessing
that...can you?
John
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesda
Is it a compiled executable? If so, you could set the sticky bit...
-Original Message-
Sent: Tuesday, March 13, 2001 12:11 PM
To: Multiple recipients of list ORACLE-L
I am running an external C procedure. The C function needs to access
afile...but it is not owned by oracle and is read
External procedures run as the user under which the external procedure listener was
started. It is not a good idea to have oracle be that user; you want the external
procedure user to have as few privileges as possible. If you want the external
procedure user to modify a file it does not own
