Re: the last login of a user to the database
From: joel garry <joel-garry_at_home.com>
Date: Wed, 16 Dec 2009 09:38:45 -0800 (PST)
Message-ID: <9026e825-7063-428a-952c-ed1d41d9d80c_at_13g2000prl.googlegroups.com>
On Dec 15, 11:43 pm, jan <janmben..._at_googlemail.com> wrote:
> Hi all,
>
> i have a database with many users like 4_0, 4_1, 4_2, 4_21, 4_22
> and so on.
> I think - if you update the Front-End software from version 4.1 to
> 4.2 the software create a new User 4_2 and will
> now work with that user. (so the database is full of old users)
>
> To prove that I'm right - i like to now the last access (last login )
> of a user to the database
>
> Is there a table in the dict that store that ?
>
> thanks a lot !!!!
Date: Wed, 16 Dec 2009 09:38:45 -0800 (PST)
Message-ID: <9026e825-7063-428a-952c-ed1d41d9d80c_at_13g2000prl.googlegroups.com>
On Dec 15, 11:43 pm, jan <janmben..._at_googlemail.com> wrote:
> Hi all,
>
> i have a database with many users like 4_0, 4_1, 4_2, 4_21, 4_22
> and so on.
> I think - if you update the Front-End software from version 4.1 to
> 4.2 the software create a new User 4_2 and will
> now work with that user. (so the database is full of old users)
>
> To prove that I'm right - i like to now the last access (last login )
> of a user to the database
>
> Is there a table in the dict that store that ?
>
> thanks a lot !!!!
If they connect through sqlnet and you have a listener log, you may be
able to parse/sort that. Also see
http://www.pythian.com/news/902/how-to-make-an-in-database-listenerlog-file/
jg
-- _at_home.com is bogus. http://inboxzero.tumblr.com/#201566635Received on Wed Dec 16 2009 - 11:38:45 CST