Oracle software installation user is a criticalHi Werner,
userid, don't open a security hole. It's better to
create a specific application user with less database
privileges than 'oracle' (especially not part of
'dba' group), which performs datapump.
I think Ajallen is right, the actual dumpfile isNo, 'umask' setting of user doing data pump will not affect default permission of dump file in OS level. Oracle will default to 640 permission.
created by the OS and the file permissions depend on
'umask' setting of the particular user. Of course
additionally we need read-write access on the
datapump directory level.
%expdp userid=system schemas=testuser directory=imp_dir
-rw-r----- 1 oracle dba 205586432 May 29 13:40 expdat.dmp