Re: I must get ID session, help me !!

From: Arup Nanda <orarup_at_hotmail.com>
Date: Sat, 21 Jun 2003 09:47:09 -0700
Message-ID: <F001.005B7166.20030621075941@fatcity.com>

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. Received on Sat Jun 21 2003 - 11:47:09 CDT