From orarup@hotmail.com Sat, 21 Jun 2003 09:47:09 -0700
From: "Arup Nanda" <orarup@hotmail.com>
Date: Sat, 21 Jun 2003 09:47:09 -0700
Subject: Re: I must get ID session, help me !!
Message-ID: <F001.005B7166.20030621075941@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Nguyen,
 
Have you tried using SYS_CONTEXT('USERENV','<attrubute_name>')?
 
where <attribute_name> may be 
 
SESSION_USER - for the user who logins in.
IP_ADDRESS - the ip address of the client machine
OS_USER - the OS user 
 
etc.
 
HTH.
 
Arup Nanda
 
----- Original Message ----- 
<BLOCKQUOTE 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Nguyen Hong 
  Thai 
  To: <A [EMAIL PROTECTED] 
  href="mailto:[EMAIL PROTECTED]">Multiple recipients of list ORACLE-L 
  
  Sent: Saturday, June 21, 2003 9:18 
  AM
  Subject: I must get ID session, help me 
  !!
  
   
  I can't get ID current session and others info: User Name, User ID, Date, 
  Time of session & transaction from Trigger.
  Please help me: <A 
  href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] or <A 
  href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] 
  
  
  Do you Yahoo!?<A 
  href="http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com">The New 
  Yahoo! Search - Faster. Easier. Bingo.