v$session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: v$session

  1. #1
    Join Date
    Jan 2002
    Posts
    38
    I need to find out if there is a view for a user who is not a sys to find out his sid, serial#. Is there a view that does what the v$session does. I'm trying to find out a way without having to grant privliages to this view. Sorry for the bad grammer but I'm in a hurry.
    Thanks
    Jason

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,966
    Why don't you just create a view of the information that you want users to look at and then create a public synonym that points to the view and give select to public on the new view.

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