Hi,
I need to use the DBMS_PROFILER package for PL/SQL
in between the procedures. I used the corresponding script located
in
Oracle_home\rdbms\admin\PROFLOAD.sql .
I ran this script, it ran without any problems.
But I am still unable to invoke the DBMS_PROFILER package,
The error is
Identifier
Run GRANT EXECUTE ON SYS.DBMS_PROFILER TO you first; it appears that
your permissions were granted through a role...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 4:59 AM
Hi,
I need to use the DBMS_PROFILER package
Satya,
pls grant the privileges from sys to the user running the DBMS_PROFILER package
Venkat
--
On Thu, 23 Jan 2003 03:59:00
Satya V Prakash wrote:
Hi,
I need to use the DBMS_PROFILER package for PL/SQL
in between the procedures. I used the corresponding script located
in
]
fmail.com cc:
Sent by: Subject: Help on DBMS_PROFILER
required
[EMAIL PROTECTED
Hi Venkat and group,
Thanx for ur replies,
It worked !! U were right.
I now connected as sys and granted permission for my user, ran the
script(PROFTAB.sql),
The table- plsql_profiler_data is now created !
Regards,
Satya Prakash
On Thu, 23 Jan 2003 C.S.Venkata Subramanian wrote :
Satya,