DBMS_PROFILER not showing proc in different owner

From: Jim Campbell <jic_at_rochester.rr.com>
Date: Wed, 21 Jan 2004 02:01:03 GMT
Message-ID: <z3lPb.64650$Su5.20796@twister.nyroc.rr.com>

Hi,

We are trying to use DBMS_PROFILER under Oracle 9.0.1. I have a procedure defined that is owned by one user. I log in as a different user, and call start_profiler through a login trigger, and then call the procedure using the syntax <owner>.<procedure>. DBMS_PROFILER does not make any record of the procedure in PLSQL_PROFILER_UNITS. When I log in as the user that owns the table and run the procedure, iI do get records. We ran the profload.sql and proftab.sql scripts under sysdba.

I did all the necessary grants, such as CREATE ANY PROCEDURE, and also added public synonyms, but have not been able to get it to see the procedure.

Any clues? Received on Tue Jan 20 2004 - 20:01:03 CST