From owner-oracle-l@CCVM.SUNYSB.EDU Mon Mar 13 23:09:34 1995 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65/1.1.8.2/01Aug94-0142PM) id AA22465; Mon, 13 Mar 1995 23:09:31 -0500 Message-Id: <9503140409.AA22465@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2) with BSMTP id 6375; Mon, 13 Mar 95 22:55:36 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 3267; Mon, 13 Mar 1995 22:45:24 -0500 Date: Mon, 13 Mar 1995 22:45:24 -0500 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Tony Jambu Subject: Trace files prob - solution X-To: leng@cougar.vut.edu.au X-Cc: ORACLE-L@CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L In-Reply-To: <9503140215.AA20858@cougar.vut.EDU.AU>; from "Leng Kaing" at Mar 14, 95 12:15 (noon) X-Orig-Date: Tue, 14 Mar 1995 14:46:36 EDT Leng > > Another option is to use an Undocumented INIT.ORA parameter, > > '_trace_files_public'. > > > > Set it to TRUE in your init.ora file. > > > > Oh by the way, I think this is an Oracle 7 'feature' > > > > Tony & co., > > I've tried both setuid and the parameter to no avail. The trace files > remain accessible by oracle only. After security considerations, I > think it best left this way. > I get a feeling you did not restart your database once you changed _trace_files_public in the INIT.ORA file or else you would have noticed that it works. Give it a go or call me if it is still a problem. ta tony ______________________________________________________________________________ _____ ________ / ___ |Tony Jambu, Database Consultant /_ _ /_ __ / |Wizard Consulting,Aust (ACN 065934778) /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003@compuserve.com FAX: +61-3-2536173 \_______/ |EMAIL:TJambu@wizard.com.au PHONE: +61-3-2536385