Home » RDBMS Server » Security » user last login date (oracle 9i)
user last login date [message #302286] Mon, 25 February 2008 03:23 Go to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
Hi all,

Is there any way to know the last login date for a specific oracle user?

Regards
Re: user last login date [message #302293 is a reply to message #302286] Mon, 25 February 2008 03:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to audit the connection for this.
You can have a look at listener.log for remote connections.

Regards
Michel
Re: user last login date [message #302373 is a reply to message #302286] Mon, 25 February 2008 07:02 Go to previous messageGo to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
Hi Michel,

if you don't mind can you tell me how to audit the connection?

Regards
Re: user last login date [message #302377 is a reply to message #302373] Mon, 25 February 2008 07:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AUDIT SESSION.

Regards
Michel
Re: user last login date [message #302541 is a reply to message #302286] Tue, 26 February 2008 01:32 Go to previous messageGo to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
Thanks a lot Michel.

Re: user last login date [message #303201 is a reply to message #302286] Thu, 28 February 2008 05:53 Go to previous message
rikfair
Messages: 22
Registered: October 2006
Location: UK
Junior Member
Hi ORA-MAN
If your still looking, this article may be worth reading. It has steps to audit the user connections, both successful and unsuccessful, and sample queries on the collected audit data.

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11100

Hope this helps
Previous Topic: Scott user locked and expired
Next Topic: Grant Objects
Goto Forum:
  


Current Time: Fri Mar 29 04:21:55 CDT 2024