Hi,
Unless something has changed in 8.x, in your parameter file:
1. Set _trace_files_public = true AND
2. Set user_dump_dest to a public directory. Make sure oracle has write
access to it.
We do this for our developers in our development and preproduction
databases.
HTH,
Steve
_____________________________
Steve Morrow
IT/Tech Support
University of South Florida
phone: 813-974-5519
[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, April 20, 2001 3:54 PM
To: Multiple recipients of list ORACLE-L
I've got a developer that says they need the unix password for oracle so
they can do a trace and run tkprof without having to jump through a bunch
of hoops. Anyone set up trace so someone other than oracle can do this?
The permissions on the trace files only allow reading by the file owner, so
setting the user into the dba group won't help.
Thanks, Dave Turner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Morrow, Steve
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).