Home » RDBMS Server » Security » Last Time User Login
Last Time User Login [message #156765] Fri, 27 January 2006 10:15 Go to next message
Messages: 120
Registered: November 2005
Senior Member
Is there a way, I can find when was the last time user logged in my database.

Re: Last Time User Login [message #156809 is a reply to message #156765] Sat, 28 January 2006 01:07 Go to previous messageGo to next message
Frank Naude
Messages: 4575
Registered: April 1998
Senior Member
SELECT sid, username, logon_time FROM v$session WHERE ...
Re: Last Time User Login [message #157139 is a reply to message #156809] Tue, 31 January 2006 08:43 Go to previous message
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
That'll only sho users currently logged in won't it?
You could use logon triggers to insert/update an audit table maybe?

Previous Topic: Table owner and table permission
Next Topic: Hash Value for Passwords Stored in Oracle
Goto Forum:

Current Time: Thu Sep 21 11:37:12 CDT 2023