Permissions for Autotrace

If you want to run AutoTrace using Toad using a non sys or system user, give your user the following select privileges:

grant select on v_$session to &traceuser.;
grant select on v_$sesstat to &traceuser.;
grant select on v_$statname to &traceuser.;

Alternately you can run $ORACLE_HOME/sqlplus/admin/plustrce.sql and then grant the PLUSTRACE role to the user that needs to run AutoTrace.

-Dave

Add new comment