RE: Permissions on datafiles

From: lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk>
Date: Tue, 9 Jan 2001 16:31:47 -0000
Message-Id: <10736.126160@fatcity.com>

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-----
From: Haunschmidt Andreas VASL/FAS
[mailto:Andreas.Haunschmidt_at_voest.co.at] Sent: 09 January 2001 13:27
To: Multiple recipients of list ORACLE-L Subject: AW: Permissions on datafiles

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

Received on Tue Jan 09 2001 - 10:31:47 CST