Re: the last login of a user to the database
Date: Wed, 16 Dec 2009 09:01:09 +0100
On Tue, 15 Dec 2009 23:43:19 -0800 (PST), jan <janmbender_at_googlemail.com> wrote:
>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
Then you could use dba_audit_session
Senior Oracle DBA Received on Wed Dec 16 2009 - 02:01:09 CST