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

Thread: IP/Terminal Name

  1. #1
    Join Date
    May 2005
    Location
    karachi, pakistan
    Posts
    2

    IP/Terminal Name

    I want to store user machine IP and MACHINE NAME into my log table. Is there any procedure, function, property or any other way to get it.
    Please reply me.

    Thanks
    SAAD N. SIDDIQUI

    EMAIL:saadnsiddique@yahoo.com
    snsiddiqui@gmail.com
    saad_n_siddiqui@hotmail.com

  2. #2
    Join Date
    Jul 2007
    Posts
    1
    Select Sys_Context('USERENV', 'TERMINAL') "Machine Name", Sys_Context('USERENV', 'IP_ADDRESS') "IP Address" From dual
    /

    check Sys_Context function...

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