Home » RDBMS Server » Security » user account locked error
user account locked error [message #567579] Wed, 03 October 2012 07:14 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello everyone,

we have a prod application which use oracle database 11g as backend and .NET technology as front end .
there is a user TESTUSER in database.
issue is that we can login in to the application, but when we try to login in database
through toad or Dbvisualizer then it gives an error of 'user account locked'.

please tell me what is the problem here.

thanks in advance.....
Re: user account locked error [message #567586 is a reply to message #567579] Wed, 03 October 2012 07:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Ask your DBA to unlock the account.

Regards
Michel
Re: user account locked error [message #567589 is a reply to message #567586] Wed, 03 October 2012 07:47 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
no sir, this is not a normal problem , because
if user account is locked from database side,then how the application is accessed same time.

thanks....
Re: user account locked error [message #567593 is a reply to message #567589] Wed, 03 October 2012 07:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Then you are not trying to connect at the same database or with the same user.

Regards
Michel
Re: user account locked error [message #567599 is a reply to message #567593] Wed, 03 October 2012 08:00 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
means sir,
it is not possible that if we are able to access the application then that user can not be locked.
Re: user account locked error [message #567600 is a reply to message #567599] Wed, 03 October 2012 08:03 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can connect through the application, you cannot connect through toad =>
1/ You do not try to connect to the same database
2/ You do not try to connect with the same user

No other alternative.

Regards
Michel

[Updated on: Wed, 03 October 2012 08:04]

Report message to a moderator

Previous Topic: Changing OID Password (2 Merged)
Next Topic: CVE-2012-3132 and Express Editions of Oracle DB
Goto Forum:
  


Current Time: Sun Dec 22 01:01:04 CST 2024