Help! Oracle UTL_FILE and pmrun

Anyone familiar with pmrun and how it affects Oracle?

I have a script setup to run an Oracle PL/SQL script which uses UTL_FILE to write to a file. I understand that Oracle will disregard the UNIX permissions and will be able to write on the directory setup regardless of the UNIX permissions.

The script runs fine when ran normally by a specific user, let say user1.

The problem occurs when running the script under pmrun. The system was setup such that user2 should run the script as user1 (pmrun was setup to run the script as user1). But when running under pmrun, we are getting a FILE_OPERATION error. I experimented and changed the access rights to the directory where the file is written to (owner of the directory is user1 and user1 has full access) so that the world has full access to the directory. This solved the problem!!! Actually, granting write and execute to the world also works.

Does this not seem weird? Oracle should be disregarding the permission rights and yet when running under pmrun, it seems to not do that.

I do not want to grant access to the world to the directory so I'm looking for alternative solutions.

Any help will be greatly appreciated.

Thanks in advance.

Arnold

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 13 2000 - 17:15:25 CST