Re: Triggers at session level

From: Andre van Winssen \(andrew\) <andrew_at_info.nl>
Date: Wed, 30 Jan 2002 17:10:50 +0100
Message-ID: <3c581b0a$0$220$4d4ebb8e@news.nl.uu.net>

Hi,
use a database logon trigger. See example below: CREATE OR REPLACE TRIGGER log_the_logon

-- to disable this trigger (f.i. if the trigger PLSQL block would fail)
-- use CONNECT INTERNAL
-- ALTER TRIGGER log_the_logon DISABLE
--

AFTER LOGON ON DATABASE
BEGIN
  insert into logtable (--);
EXCEPTION
when others then null;
END;
/
You could create a similar BEFORE LOGOFF trigger

Regards,
Andre van Winssen

"Patrick J." <patrickREMOVE.jTHIS_at_kneip.com> wrote in message news:3c5817ce$1_1_at_news.vo.lu...
> Hi,
>
> I am wondering if some predefined triggers are available when a session
> start and end? The aim is to log the connections of some specific users.
>
> Thanks,
>
> Patrick J.
>
>
Received on Wed Jan 30 2002 - 10:10:50 CST