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

Thread: session variables

  1. #1
    Join Date
    Feb 2005
    Posts
    49

    Question session variables

    Dear developers,

    I would like to make an Audit Table, but I do not want to send the information from the application I want it to be extracted from the Database, from the session ? what are the variables that I can extract friom session from example can I extract the PC Network name from the session.

    Thanks
    Aiman H. Al-Jumoay

  2. #2
    Join Date
    Oct 2002
    Posts
    109
    Check ora_dic_obj_name
    but sorry i am not sure

    regards,
    Praveen

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    userenv or sys_context functions

  4. #4
    Join Date
    Feb 2005
    Posts
    158
    "can I extract the PC Network name from the session"

    Partly comes down to how the end user connects to the database. If there is something in between (eg an application server) all the database knows is that the connection is from the application server (plus anything the application server 'tells it', but obviously that is part of the application).

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