From daemon Fri Jan 26 16:14:35 1996
Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM)
 id AA02397; Fri, 26 Jan 1996 16:14:32 -0500
Message-Id: <9601262114.AA02397@alice.jcc.com>
Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3)
   with BSMTP id 6088; Fri, 26 Jan 96 15:34:57 EST
Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 5687; Fri, 26 Jan 1996 12:52:46 -0500
Date:         Fri, 26 Jan 1996 12:50:12 -0500
Reply-To: "ORACLE database mailing list." <ORACLE-L@ccvm.sunysb.edu>
Sender: "ORACLE database mailing list." <ORACLE-L@ccvm.sunysb.edu>
From: Jennifer Pivovar <jpivovar@SPROCKET.LCP.COM>
Subject:      Re: user_dump_dest - setting user access
X-To:         "ORACLE database mailing list." <ORACLE-L@ccvm.sunysb.edu>
To: Multiple recipients of list ORACLE-L <ORACLE-L@ccvm.sunysb.edu>
In-Reply-To:  <9601261725.AF02843@ lcp.com>

Jeff -

> Is there any way to set the default protection for the trace files that
> are created in the user_dump_dest directory?  I have tried setting the
> protection mode at the directory level, but it does not let users access
> newly created trace files.

The only way to get world reads on the trace files in v7 is to set an
undocumented init parameter:
        _trace_files_public = TRUE

if you put this line in your init.ora file & bounce the db, you'll get
the results you seek.  as with all undocumented parameters, you use at
your own risk - their use is not supported by Oracle.

jpivovar@sprocket.lcp.com

