I did not see many answers to your question.
The Oracle 816 doc mentions to set umask to 022 for
the Oracle account.
Bill Burke, "the kinder and gentler dba" , has made a
document a long time ago where it was mention to set
permission to 750 on datafiles. That was for Oracle 7
before there was the oinstall group.
Now the datafiles belong to the oinstall group,
setting umask to 022 for the Oracle account allows a
dba (someone in the dba group) to see the datafile at
the OS level but also anybody else.
- lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk> a
écrit : > Thanks for the reply but the oracle umask is
the one
> I was looking at. It is
> fine. If I touch a file it gives me 664.
>
> regards
>
> > Lee Robertson
> > Acxiom
> > Tel: 0191 525 7344
> > Fax: 0191 525 7007
> > Email: lerobe_at_acxiom.co.uk
> >
>
>
> -----Original Message-----
> [mailto:Andreas.Haunschmidt_at_voest.co.at]
> Sent: 09 January 2001 13:27
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Haunschmidt Andreas VASL/FAS
> INET: Andreas.Haunschmidt_at_voest.co.at
>
> 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).
> --
> 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).
Stephane Paquette
Received on Thu Jan 11 2001 - 10:00:57 CST