OraFAQ Forum: Security » user last login date

Home » RDBMS Server » Security » user last login date (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

user last login date [message #302286]

Mon, 25 February 2008 03:23

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

Report message to a moderator

Re: user last login date [message #302293 is a reply to message #302286]

Mon, 25 February 2008 03:48

Michel Cadot
Messages: 68455
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

Report message to a moderator

Re: user last login date [message #302373 is a reply to message #302286]

Mon, 25 February 2008 07:02

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

Report message to a moderator

Re: user last login date [message #302377 is a reply to message #302373]

Mon, 25 February 2008 07:13

Michel Cadot
Messages: 68455
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

AUDIT SESSION.

Regards
Michel

Report message to a moderator

Re: user last login date [message #302541 is a reply to message #302286]

Tue, 26 February 2008 01:32

ORA-MAN
Messages: 24
Registered: January 2008
Location: ===

Junior Member

Thanks a lot Michel.

Report message to a moderator

Re: user last login date [message #303201 is a reply to message #302286]

Thu, 28 February 2008 05:53

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

Report message to a moderator

Previous Topic:	Scott user locked and expired
Next Topic:	Grant Objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 09 13:10:10 CDT 2023