Mas Indra terima kasih atas responnya.. tapi sy masih bingung nehkalo 
menggunakan package ini kita harus selalu masukin host_name nya yah?kalo untuk 
mencatat user mana aja yang login di isqlplus, darimana kita dapat hostname si 
user tersebut?----- Original Message ----- 
  From: Indra Armansyah 
  To: [email protected] 
  Sent: Friday, March 16, 2007 9:27 AM
  Subject: Re: [indo-oracle] Dapetin IP address client di isqlplus



  select UTL_INADDR.get_host_address('HOST_NAME') from dual;

  Salam,

  Indra Armansyah.
  [EMAIL PROTECTED]

  ----- Original Message ----- 
  From: Oscar Wilyanto 
  To: [email protected] 
  Sent: Friday, March 16, 2007 7:55 AM
  Subject: [indo-oracle] Dapetin IP address client di isqlplus

  Dear Masters,

  Saya ingin membuat trigger yang mencatat semua ip address yang melakukan 
loggin ke database, terutama yang melalui isqlplus..

  Bagaimana caranya? apakah ada paket khusus untuk ini?

  Thanks in Advance
  Oscar

  ----------------------------------------------------------
  This message contains confidential information and is intended only for the
  individual named. If you are not the named addressee you should not
  disseminate, distribute or copy this e-mail. Please notify the sender
  immediately by e-mail if you have received this e-mail by mistake and delete
  this e-mail from your system. E-mail transmission cannot be guaranteed to be
  secure or error-free as information could be intercepted, corrupted, lost,
  destroyed, arrive late or incomplete, or contain viruses. MKD Group therefore
  does not accept liability for any errors or omissions in the contents of this
  message, which arise as a result of e-mail transmission. If verification is
  required please request a hard-copy version. 

  MKD Group, www.mkdgroup.com
  ----------------------------------------------------------

  [Non-text portions of this message have been removed]

  ----------------------------------------------------------

  No virus found in this incoming message.
  Checked by AVG Free Edition.
  Version: 7.5.446 / Virus Database: 268.18.11/722 - Release Date: 3/14/2007 
3:38 PM

  [Non-text portions of this message have been removed]



   



------------------------------------------------------------------------------
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. MKD Group therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version. 

MKD Group, www.mkdgroup.com
------------------------------------------------------------------------------


[Non-text portions of this message have been removed]

Kirim email ke