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

On Tue, 24 Nov 1998 15:15:28 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:

>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,

From this, are you implying that a login/logout trigger will be/is supported in Oracle 8.1/8i?

Ciao
Fuzzy
:-) Received on Wed Nov 25 1998 - 00:00:00 CST