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

Thanks
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: 4579
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
JSI2001
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?

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


Current Time: Fri Mar 29 00:35:52 CDT 2024