Hi,
under sys I've runned the script tracetab.sql, which has creted the two tables : PLSQL_TRACE_EVENTS and PLSQL_TRACE_RUNS.
after that i grant the necessary privileges (under sys):
GRANT DELETE, INSERT, SELECT ON SYS.PLSQL_TRACE_EVENTS TO HR;
GRANT DELETE, INSERT, SELECT ON SYS.PLSQL_TRACE_RUNS TO HR;
So, now i connect with HR to the same database and run the following:
select * from PLSQL_TRACE_EVENTS
wich give me:
ORA-00942: table or view does not exist
and
select * from PLSQL_TRACE_RUNS
which give me:
ORA-00942: table or view does not exist
while if i run the trace with the pl/sql developer, it works right, can some one tell me why?
thanks
Francesco