Re: Triggers at session level

From: AndrewV <andrew.velichko_at_moh.gov.on.ca>
Date: 30 Jan 2002 10:45:49 -0800
Message-ID: <335c961b.0201301045.3c672bac@posting.google.com>

Hi!

We have Oracle 8.1.5 and it allows us to create triggers like the following one:
CREATE OR REPLACE TRIGGER On_Logon
AFTER LOGON
ON The_user.Schema
BEGIN
Do_Something;
END;
For more information see "Application Developer’s Guide - Fundamentals"

Regards,

Andrew Velichko
Brainbench MVP for Oracle Developer 2000 http://www.brainbench.com

"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 - 12:45:49 CST