Ok then why would my oem on one solaris system write files as 664 and another write files as 644?
both databases have '_trace_files_public = TRUE' parameter. both are writing out files using utl_file. The only difference is one sits on a Netapp filer. I am still confused. Kathy p.s. I know your carpenter. He does good work. -----Original Message----- Sent: Monday, July 08, 2002 1:25 PM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
