Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Permissions on User Trace Files

RE: Permissions on User Trace Files

From: Jim Silverman <jsilverman_at_Solucient.com>
Date: Wed, 3 May 2006 11:40:51 -0400
Message-ID: <2D1EFB433A527D4681B80C94B71E359804650A47@aaexchange01.HEALTH.AD>


Thanks!



Jim Silverman
Senior Systems Database Administrator
Solucient, LLC
Telephone: 734-669-7641
FAX:            734-930-7611 
E-Mail:         jsilverman_at_solucient.com 

		From: Daniel W. Fink [mailto:danielwfink_at_yahoo.com] 
		Sent: Wednesday, May 03, 2006 11:34 AM
		To: Jim Silverman
		Cc: oracle-l_at_freelists.org
		Subject: Re: Permissions on User Trace Files

		Set _trace_files_public = true at the system level.
		
		Jim Silverman wrote: 
		Hey, all.
		Does anybody know an easy way to provide read privilege
for all users on trace files generated by SQL trace? Environment is Oracle 10g on Sun Solaris. I know that we can write a cron job to periodically wake up and explicitly chmod the files in USER_DUMP_DEST. However, I was hoping that we could avoid this sort of nonsense and just ask Oracle to set the appropriate mode (644) on these files when they are created.
		TIA.
		=====================================
		Jim Silverman
		Senior Systems Database Administrator
		Solucient, LLC
		Telephone:   734-669-7641
		FAX:            734-930-7611
		E-Mail:         jsilverman_at_solucient.com


--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 03 2006 - 10:40:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US