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 !!!!

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

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

AUDIT SESSION;



-- 
http://mgogala.freehostia.com

On Dec 15, 11:43=A0pm, jan <janmben...@googlemail.com> wrote:
> Hi all,
>
> i have a database with many users like 4_0, =A04_1, =A04_2, =A04_21, 4_22
> and so on.
> I think - if you update the Front-End software from version 4.1 to
> 4.2 =A0the 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 =A0- 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
--
@home.com is bogus.
http://inboxzero.tumblr.com/#201566635