Who is the user of 'our' umask ? Is this the same user as the
oracle account ?
I suppose you are on a UNIX like system. In this case, the oracle
executables
should have the 'set user id' and the 'set group id bit' set, which
means you got
effectively the umask and permissions of the oracle user and his (
dba ) group.
You can see this funny bits ( the 's' in rws--s--x) if you issue
following commands on your shell prompt, eg:
ls -l $ORACLE_HOME/bin | grep rws
-rwsr-s--x 1 oracle dba 213490 Nov 19 1999 lsnrctl
-rwsr-s--x 1 oracle dba 199964 Nov 19 1999 onrsd
-rwsr-s--x 1 oracle dba 20485217 Nov 19 1999 oracle
-rwsr-s--x 1 oracle dba 43322 Nov 19 1999 osslogin
-rwsr-s--x 1 oracle dba 185987 Nov 19 1999 tnslsnr
-rwsr-s--x 1 oracle dba 31675 Nov 19 1999 tnsping
-rwsr-s--x 1 oracle dba 109801 Nov 19 1999 trcasst
-rwsr-s--x 1 oracle dba 38246 Nov 19 1999 trcroute
So maybe oracles umask should be changed.
Hope this helps
Andreas.
> ----------
> Von: lerobe - Lee Robertson[SMTP:LEROBE_at_acxiom.co.uk]
> Gesendet: Dienstag, 9. Januar 2001 10:30
> An: Multiple recipients of list ORACLE-L
> Betreff: Permissions on datafiles
>
> Hi,
>
> Anyone have an idea how Oracle allocates its file permissions when adding
> datafiles to a tablespace. I thought it would use umask but as our umask
> is
> set to 002, the resultant file permissions after adding a file would
> suggest
> that this is not the case.
>
> Hope someone can provide an answer
>
> Regards
>
> Lee
>
>
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.
> If you have received this communication in error, please
> re-send this communication to the sender and delete the
> original message or any copy of it from your computer
> system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: lerobe - Lee Robertson
> INET: LEROBE_at_acxiom.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jan 09 2001 - 07:26:45 CST