try doing a unix(os) 'grep -i <os_name>' in the listener log
(example UNIX>grep -i user_name listener.log) or you can create a logon
trigger to write it some place.

Jeff

-----Original Message-----
From: oracledba-return-130808-JEFFERY.L.SCHRENK=saic.[Email address protected]
[mailto:oracledba-return-130808-JEFFERY.L.SCHRENK=saic.[Email address protected]
n Behalf Of LeRoy Martin
Sent: Monday, July 31, 2006 1:25 PM
To: LazyDBA Discussion
Subject: User Last login


Is there a view that shows the last login date/time for Oracle users?

Thank you,

Martin


----------------------------------------------------------------------------
--
----
This message is intended only for the personal and confidential use of the
designated recipient(s) named. If you are not the intended recipient of this
message, you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited. This
communication is for information purposes only and should not be regarded as
an offer to sell or as a solicitation of an offer to buy any financial
product, an official confirmation of any transaction, or as an official
statement of Aurora Loan Services. Email transmission cannot be guaranteed
to be secure or error-free. Therefore, we do not represent that this
information is complete or accurate and it should not be relied upon as
such. All information is subject to change without notice.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page