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

You can't change any v$ view, because it's a virtual view! It doesn't exist as a database object, oracle provides it for convenience. If you want just to have a log file, use sqlnet and listener will log all users logins/logouts. You'll have to change some listener settings. To catch a change of a password, you can create a trigger on sys.user$ table, but I wouldn't recommend it. It's better not to mess with Oracle internal tables.

In article <7cakgb$r6q$1_at_nnrp1.dejanews.com>,   grelaud_at_my-dejanews.com wrote:
> 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
>

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