ORACLE 7.3 - Is There a way to detect a user connection when it happens

From: <grelaud_at_my-dejanews.com>
Date: Fri, 12 Mar 1999 08:50:22 GMT
Message-ID: <7cakgb$r6q$1@nnrp1.dejanews.com>

Hello everybody,

For security reason, I have to detect when a user is connecting to a database and then to check the last time he change its password.

After some search in the Oracle documentation I was thinking that the best way was to add a trigger on each insert into the "v$session" table... But this table is recovered by a view named also "v$session".

I have tried as the "SYS" user to drop this view without success !

Does anybody out there can help me !

Thank you in advance for your help.

Cordially, Jean-Michel GRELAUD

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 12 1999 - 02:50:22 CST