Re: DBMS_PROFILER not showing proc in different owner

HI

To use the profiler you need to make sure it is installed by running the script $ORACLE_HOME/rdbms/admin/profload.sql - this script runs tow other scripts dbmspbp.sql and prvtpbp.plb to install the profiler.

To use the profiler the tables need to be created by running $ORACLE_HOM E/rdbms/admin/proftab.sql - you can run this script as the user who will run the profiler or in a general schema such as system.

To use the profiler do:

start profiler
run pl/sql
stop profiler
run reports

the reports available are: $ORACLE_HOME/rdbms/admin/profrep.sql and $ORACLE_HOME/rdbms/admin/profsum.sql

because you are running in a trigger, make sure that you have granted explicit permissions on the necessary objects. I would also run a trace to see what it is doing.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.