Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

the last login of a user to the database

2 views
Skip to first unread message

jan

unread,
Dec 16, 2009, 2:43:19 AM12/16/09
to
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 !!!!

Sybrand Bakker

unread,
Dec 16, 2009, 3:01:09 AM12/16/09
to

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

Mladen Gogala

unread,
Dec 16, 2009, 8:09:46 AM12/16/09
to

AUDIT SESSION;

--
http://mgogala.freehostia.com

joel garry

unread,
Dec 16, 2009, 12:38:45 PM12/16/09
to

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

0 new messages