Re: the last login of a user to the database

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Wed, 16 Dec 2009 09:01:09 +0100
Message-ID: <jr4hi5h74bkkirkmm5l3f9u975omulan5t_at_4ax.com>

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

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