Home » RDBMS Server » Security » ORA-20007 (Oracle 11.1.0.7.0 , Unix)
ORA-20007 [message #516295] Sat, 16 July 2011 04:36 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

When i try to change the user account password, i get following error.

alter user bala
identified by Ju4hlsd2;

*
ERROR at line 1:
ORA-20178: ORA-20176: ORA-28003: password verification for the specified
password failed
ORA-20007: Password cannot consist of sequences of 3+ characters from the
userid

Please advice how to set the password based on the error.

Thanks
Re: ORA-20007 [message #516298 is a reply to message #516295] Sat, 16 July 2011 04:54 Go to previous messageGo to next message
John Watson
Messages: 4683
Registered: January 2010
Location: Global Village
Senior Member
This error is begin returned by the password verification function that you have specified in your profile. You know all about profiles, from your previous question.
Over to you, now: I won't give you any more free help until you prove that you have read the relevant documentation again, and done some investigation. You know how to do this.
Re: ORA-20007 [message #516311 is a reply to message #516295] Sat, 16 July 2011 09:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again, YOU (or your application manager or DBA) define the rules.
This is NOT an Oracle error but a functional one.

In addition, the message is ONCE AGAIN quite clear (if you can trust it as it seems your developers have the same (infra-)level than you).

Regards
Michel

[Updated on: Sat, 16 July 2011 09:47]

Report message to a moderator

Re: ORA-20007 [message #516335 is a reply to message #516311] Sat, 16 July 2011 14:14 Go to previous messageGo to next message
Littlefoot
Messages: 19690
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Your command : alter user bala identified by Ju4hlsd2;
Error message: Password cannot consist of sequences of 3+ characters from the userid.


Maybe I don't understand it, but - where does "Ju4hlsd2" contain a sequence of 3+ characters from "bala"?
Re: ORA-20007 [message #516337 is a reply to message #516335] Sat, 16 July 2011 14:18 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Tbis is why I said: "if you can trust it as it seems your developers have the same (infra-)level than you" (as some previous topics seem to show it).

Regards
Michel
Re: ORA-20007 [message #516380 is a reply to message #516335] Sun, 17 July 2011 04:35 Go to previous message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

This error i fixed it. The username and the password i gave was different. Now i understood the meaning of the error.

Thank you for your effort in making me understand the meaning of the error.
Previous Topic: Lock user accounts
Next Topic: Unable to log on as sysdba
Goto Forum:
  


Current Time: Thu Oct 23 00:28:23 CDT 2014

Total time taken to generate the page: 0.05940 seconds