Oracle reports being created with less permissions
We have Oracle reports 10g created by the the Oracle batch user. The permission of the report created is :-
-rw-r----- 1 oracle dba 6142 31 May 23:53 EASSR001.lis
/u/qssdev1/logs GBWONW9AP10 (AS1012TZ)>
I would like the report to be created automatically with permissions -rw-rw-r-. How can this be achieved automatically when the file is created?
If i change the umask 002 in the .profile of the AIX 6.1 server environment of the oracle profile and then run the command :-
touch lazybones2.lis
We get :-
-rw-rw-r-- 1 oracle dba 0 01 Jun 09:30 lazy_bones2.lis
This is the correct permissions we require, however when the oracle report is run automatically the file is created as