Help required for system database trigger

From: <kishanthakker_at_gmail.com>
Date: 9 Apr 2007 04:22:31 -0700
Message-ID: <1176117751.199535.69390@p77g2000hsh.googlegroups.com>

I will be highly obliged if any one can help me on

Creating Database trigger for event of database login.

We have Oracle9i Enterprise Edition Release 9.2.0.4.0 - ported on Redhat Linux ES rel. 4.

My SPECIFIC Requirement is

I want to trap the 'log in' event which is NOT initiated by Oracle forms, Oracle reports and Oracle Plsql.

i.e. any 'login' other than these programs from windows98/windowsXP/ Windows2000 should be restricted.

I am unable to find any database function which returns this program names.

some hint on the matter will really be helpful.

Thanx in Advance

Kishan Thakker Received on Mon Apr 09 2007 - 06:22:31 CDT