Oracle-L: RE: slightly OT, permissions unix/oracle puzzler

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Mon, 08 Jul 2002 12:25:06 -0800
Message-ID: <F001.0049190F.20020708122506@fatcity.com>

Kathy,

> Ok, I log in as oracle, touch a file I get 664 permission on it.
>
> But when I create a file through OEM or a plsql procedure I
> get 644 permissions.
>
> My umask is 02.

The umask value is overwritten by the program's mode of writing the file. In other words, umask is the default mode when an override is not specified. For example, the trace files created by the Kernel do not have world read permissions regardless of umask - they are set to world-read using the '_trace_files_public = TRUE' parameter which instructs the kernel to create these files in a world-readable mode.

Hth!
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details!

The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.com

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 Mon Jul 08 2002 - 15:25:06 CDT