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

From: Hasso Brück <hasso_at_*remove*to*mail*korel.ee>
Date: Fri, 12 Mar 1999 14:10:30 +0200
Message-ID: <7cavi2$mdp$1@kadri.ut.ee>

>way was to add a trigger on each insert into the "v$session" table...
...skipped ...
>I have tried as the "SYS" user to drop this view without success !
v$* stuff are virtual tables/views. It is something like information about active oracle users is mapped to v$session table so you can get some information about logged sessions. This is mostly read-only info, and those tables/views cannot be used to update actual information. That's why they are called _virtual_.

You cannot just delete row from v$session table and hope that this session will be disconnected and so on... ;-)

---
Hasso Brück
Technical Manager
Korel SYS Ltd. Received on Fri Mar 12 1999 - 06:10:30 CST