DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Unable To See Traceid Using V$process

  1. #1
    Join Date
    Jan 2007
    Posts
    5

    Unable To See Traceid Using V$process

    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 ?

  2. #2
    Join Date
    Dec 2006
    Location
    hyderabad
    Posts
    21

    traceid

    Grant dba/admin to test user
    and then try for trace

    or
    in Oracle 10g we have plustrace role
    Last edited by girirajdba; 01-15-2007 at 12:22 PM.

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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?

  4. #4
    Join Date
    Dec 2006
    Location
    hyderabad
    Posts
    21

    traceid

    Grant select_catalog_role to test user

    (this role gives access to data dictionary views & resources)

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by girirajdba
    Grant select_catalog_role to test user

    (this role gives access to data dictionary views & resources)
    You should grant the least amount of privileges to each schema that allows them to do their job. If that weren't the case, then there would be no need for privileges.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width