Re: LOGIN TRIGGER

On Thu, 30 Nov 2000 20:58:23 GMT, ketan1_at_my-deja.com wrote:

>Can a trigger be used on a login event (When a user initially logs
>into an Oracle database) ?
>
>And, can a trigger that references v$session be used on a login event?
>
>If so, can someone please provide SAMPLE CODE on allowing or denying
>access to users based on the application that they are trying to access.
>
>
>Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Don't know too much, but I use this.

CREATE OR REPLACE TRIGGER Data_Logon_Trigger AFTER LOGON
ON SCHEMA
BEGIN
    EXECUTE IMMEDIATE
 'ALTER SESSION SET NLS_DATE_FORMAT = ''DD-MON-YYYY HH24:MI:SS'''; END Data_Logon_Trigger;
/

Brian Received on Thu Nov 30 2000 - 15:58:07 CST