Re: Control user Login ?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 13 Feb 2002 18:04:46 +1100
Message-ID: <3c6a101a$0$18471$afc38c87@news.optusnet.com.au>

Yes, depending on your version.

8i has a 'after logon on database' trigger event, so it wouldn't be too hard to create a journal table, create an "after logon database if name='SMITH'... sort of insert insert into journal table.... things like 'who are you', 'what's the time'" and so forth.

Otherwise, no.

Regards
HJR "Andreas Wizemann" <AWizemann_at_fvvag.de> wrote in message news:vrtj6u42o3hd8l1iipq7ummav9d5bsq1mo_at_4ax.com...
> Hi,
> is there a way to know at which time a user was last connected to a
> database (if he is currently NOT connected) ?
> Is there also a way to see how long a user has been connected ?
>
> Regards
> Andreas
> Andreas Wizemann
Received on Wed Feb 13 2002 - 01:04:46 CST