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
