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).
