Trace files prob - solution

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_at_compuserve.com FAX: +61-3-2536173
 \_______/                  |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-2536385