Cannot See Traceid

[souj]

Hello,
I connect as TEST user in Oracle 10g.I can alter the session and set the TRACEFILE_IDENTIFIER='GOOD'.
But I cannot acces the V$ process from the user to see the TraceID.It says " Table or view does not exist".

I connect as SYS and can acess V$process but the SYS user does not show the TRACEID of TEST user.

I tried granting select on V$process from SYS account to TEST user.But says " can grant only on fixed tables/views"

Any idea on how to see the TRACEID ?

[ebrian]

You could create a view against the TRACEID column in V$PROCESS and grant privileges to PUBLIC or just reset the TRACEFILE_IDENTIFIER.