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

Thread: How to make user access their 'user_session' table?

  1. #1
    Join Date
    Jun 2000
    Posts
    55
    My application requires the user access 'user_session' table? How to make that table visible?

  2. #2
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    what you mean with 'user_session' table?

  3. #3
    Join Date
    Jun 2000
    Posts
    55
    If you log into your database, you can do 'desc user_tables', user_session is also that kind of table belongs to sys. But I don't know how to make it usable

  4. #4
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    i never heared about user_session table ...
    (however you can try with "select any table" grant)

  5. #5
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    What database version are you using ?
    There is no user_session Table in Oracle 8 or 8i

    you may want to look in v$session view

    - Rajeev
    Rajeev Suri

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