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

Thread: About v$session

  1. #1
    Join Date
    Dec 2000
    Posts
    87
    Hi all,

    I was trying to select v$session table from a procedure, and when I'm compiling it, it kept getting me errors.

    I was trying to do this...

    Insert into(.......)
    select.....from v$session
    where....
    group by....

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    65/3 PL/SQL: SQL Statement ignored
    67/65 PLS-00201: identifier 'SYS.V$SESSION' must be declared


    Is there any pre-requirement?


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Give the user who executes this procedure the access to

    SELECT_CATALOG_ROLE

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2000
    Posts
    87

    Angry

    Somehow it didn't work!
    Any other possibilities?

  4. #4
    Join Date
    Dec 2000
    Posts
    87
    I found the answer....

    The user execute this procedure need to be granted with
    SELECT ON V_$SESSION view from SYS.

    GRANT SELECT ON V_$SESSION TO username;


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