OraFAQ Forum: Security » Last Time User Login

Home » RDBMS Server » Security » Last Time User Login

Fri, 27 January 2006 10:15

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

Sat, 28 January 2006 01:07

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

SELECT sid, username, logon_time FROM v$session WHERE ...

Tue, 31 January 2006 08:43

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: Sat Feb 21 00:57:40 CST 2026