-
Cannot See Traceid
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 ?
-
You could create a view against the TRACEID column in V$PROCESS and grant privileges to PUBLIC or just reset the TRACEFILE_IDENTIFIER.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|