Home » RDBMS Server » Server Administration » Account Lock (10.2.0.2)
Account Lock [message #378463] Tue, 30 December 2008 09:24 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
One of my db account got locked.I unlocked it.
The reason behind account lock is excessive attempt to login  with
wrong password.Is there any way I can see the user who
tried to attempt so many times with wrong password.
Regards,
Varun Punj.,
Re: Account Lock [message #378465 is a reply to message #378463] Tue, 30 December 2008 09:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Is there any way I can see the user who tried to attempt so many times
The user /schema you just unlocked was trying to login.
A bit ambiguous?.
If multiple users are allowed to use the same
database login, it would be hard. May be you can trace machine it originated from etc.


[Updated on: Tue, 30 December 2008 09:35]

Report message to a moderator

Re: Account Lock [message #378467 is a reply to message #378465] Tue, 30 December 2008 09:41 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thanks Mahesh,
I have one more basic question:-
How do I know machine It originated from??
Regards,
Varun Punj,
Re: Account Lock [message #378469 is a reply to message #378467] Tue, 30 December 2008 09:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Enable audit session for whenever not successful.
You get what you want in DBA_AUDIT_SESSION.

http://stanford.edu/dept/itss/docs/oracle/10g/server.101/b10755/statviews_2050.htm
Re: Account Lock [message #378471 is a reply to message #378463] Tue, 30 December 2008 09:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Activate audit on session.

Regards
Michel
icon6.gif  Re: Account Lock [message #378482 is a reply to message #378471] Tue, 30 December 2008 10:37 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thanks Mahesh and Michel
Previous Topic: Shared server configuration
Next Topic: Transporting Datafiles from one server to another
Goto Forum:
  


Current Time: Fri Nov 29 15:43:29 CST 2024