Hello,

I have a problem that I can't resolve. I hope that someone have a
response.

I use the package DBMS_DATAPUMP to do an export of my database into a
file.
The export operation is done correctly and the file appears correctly
on the UNIX filesystem.

Here is the output of the "ls -l" command :
-rw-r-----    1 oracle   dba        614400 Jan 28 16:43 export.dmp

The exported file permissions are set by default as shown below.

The problem is that I have to do some actions that need write
permissions on this file with a distant user via SSH (that user cannot
be oracle).

My question is :
How to modify the default permission of the file to set the write
permission to the group or others?
It is possible with a specific Oracle Package ? Is there any
solution ?

I show on another thread that we can modify the umask of the user
oracle but I also cannot do this (professionnal restriction.)

Thanks by advance for your help.

Regards.

Damien

Comments embedded.
On Jan 28, 11:14 am, Damien <damien.will...@gmail.com> wrote:

What could those 'actions' be?  Why would a user other than 'oracle'
need to access that file?  It's an export of a schema/database that
normally only 'oracle' would need to process.

Modify the umask for the 'oracle' account.

Not to my knowledge.

Modify the umask, as I said earlier.

In that case you'll need to write a 'wrapper' script to run your
dbms_datapump call, and in that script alter the permissions on the
resulting file.

David Fitzjarrell

Hello David,

First, Thanks for your response.

I have to remove the exported files after having transferred then on
our server.
The transfer is made by a shell script which connects to the remote
server where are localized the exported dump files.
Then after transferring, I have to clean the transferred dump files.

The distant server where are localized the dump files can be accessed
via SSH only with a specific user.

In my case, it is impossible because modifying the umask would have
effect on all output files generated by the user Oracle. The database
is critical and the DBA does not permit this action.

I will work on this way.

Thanks a lot.

Regards.

Damien.

In order to remove a file, other user needs a write permission on a
parent directory, not the file itself; you have to chmod o+w for a
directory containing the dump.

Regards