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).

Reply via email to