Re: the last login of a user to the database

From: Sybrand Bakker <>
Date: Wed, 16 Dec 2009 09:01:09 +0100
Message-ID: <>

On Tue, 15 Dec 2009 23:43:19 -0800 (PST), jan <> 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 !!!!

There is not.
You need to enable auditing (by changing the parameter audit_trail to db) and issue
audit connect

Then you could use dba_audit_session

Sybrand Bakker
Senior Oracle DBA Received on Wed Dec 16 2009 - 02:01:09 CST

Original text of this message