Profiler - Required Rights

[archer]

Hi,

i wish to put a package method through the profiler and i want to do this as someone who is not a DBA.

PLD very helpfully informs me that the profiler tables do not exist and offers to create them for me. i click 'go on' and it fails with ORA-01031: insufficient priviledges.

Can you tell me what rights are required in order to allow PLD to create the tables for me?

thanks.

 

[Killservice]

Hi,

for me is better to know ddl to "self" create this tables.
In one case I can't bekome more rights for user, who can execute proc, to create this tables, but my dba will create for me this tables.
Is this possible?

 

[archer]

Here's what i've tried so far:

- log on as schema owner so that PLD creates the tables for me
- explicitly grant all on 3 tables PLSQL_PROFILER_RUNS, PLSQL_PROFILER_UNITS, PLSQL_PROFILER_DATA and 1 sequence
PLSQL_PROFILER_RUNNUMBER
- explicitly grant execute on dbms_profiler

then

PLD is happy that the tables do exist but comes up with a pop-up that says Error starting Profiler: Result = 2

any ideas?

 

[William Robertson]

You don't need to be a DBA, but you do need to be able to either create tables in your current schema (requires CREATE TABLE privilege) or else perhaps create them in another schema and set up grants and synonyms so the profiler can just 'insert into plsql_profiler_runs' etc as if they were your own tables (the schema you create them in will additionally need CREATE SYNONYM privilege).

(I haven't tested the second approach.)