Re: Login in/out (i.e. session) TRIGGERS???

A copy of this was sent to Nnoor_at_cris.com (NNOOR) (if that email address didn't require changing) On 23 Nov 1998 12:13:51 PST, you wrote:

>
>Unix has .login and .logout scrips which run when a user
>logs in and out. Are there similar options in Oracle. I
>am using Oracle 7.3.3 (Oracle8 could also be used) on
>Windows NT4 and want to execute some PL/SQL code in Oracle
>when a user logs in or out. It can be done in the application
>but I want it to be a trigger like thing where the execution
>is (somewhat) guarenteed. What is the best way to do it???
>
>Thanks and Regards,
>Nasir (nnoor_at_cris.com)

Prior to Oracle8i (8.1) this must be done in the application. Various tools (eg: SQLPLUS has a login.sql file it runs upon startup, FORMS fires the ON-LOGON trigger) have their own ways to do it as well...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.