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