Quote Originally Posted by girirajdba
Grant dba/admin to test user
and then try for trace

or
in Oracle 10g we have plustrace role
Why not just grant select on V_$process?