Oracle Reports (MOSC)

MOSC Banner

Oracle reports being created with less permissions

edited Jun 1, 2012 8:14AM in Oracle Reports (MOSC) 1 comment
Hi All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center