RE: login trigger

[Leonard, George]

Title: ROWID question?

Problem solved     You can get the sid from v$mystat, having this we can then query v$session for the rest.   George ________________________________________________ George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web:   http://www.didata.co.za   You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -----Original Message----- From: Leonard, George Sent: 22 October 2002 18:44 PM To: Multiple recipients of list ORACLE-L Subject: login trigger   Hi all   I need to record the time, sun process id and oracle proc id when a user connects.   This needs to be done via a trigger, does someone have something like this handy, I am battling trying to find out in a trigger what the user's information is.   thx   George ________________________________________________ George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web:   http://www.didata.co.za   You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!