Error Ora 28003

#214223] Mon, 15 January 2007 08:19 Sham3179 Messages: 6Registered: January 2007 Junior Member Hi I just copied across some users from a oracle 8.1.7. database to a 10g database which has the

Alter Profile Default Limit Password_verify_function Null

password verification set up. It did not copy the oracle users across. So ora-20009 oracle error I tried creating the oracle user manually and now I get this ora-28003 error. I tried switching that password verification ora-28007 off but still I get the error. Anyone has any idea why this is happening? Report message to a moderator Re: Ora-28003 When updating user details [message #214224 is a https://mohamedazar.com/2010/04/11/ora-28003-password-verification-for-the-specified-password-failed/ reply to message #214223] Mon, 15 January 2007 08:26 ebrian Messages: 2794Registered: April 2006 Senior Member How did you disable the password verify function? Report message to a moderator Re: Ora-28003 When updating user details [message #214233 is a reply to message #214224] Mon, 15 January 2007 09:00 Sham3179 Messages: 6Registered: January 2007 Junior Member I set the profile value to NULL. http://www.orafaq.com/forum/t/75336/ "alter profile default limit password_verify_function null;" Another strange thing is that, now after setting this to null, I can create new users. But I cannot update existing users. Report message to a moderator Re: Ora-28003 When updating user details [message #214236 is a reply to message #214233] Mon, 15 January 2007 09:02 ebrian Messages: 2794Registered: April 2006 Senior Member You should set the password_verify_function to UNLIMITED instead of null. Report message to a moderator Re: Ora-28003 When updating user details [message #214240 is a reply to message #214223] Mon, 15 January 2007 09:09 Sham3179 Messages: 6Registered: January 2007 Junior Member Could you please explain what is the reason in setting it to UNLIMITED? Report message to a moderator Re: Ora-28003 When updating user details [message #214241 is a reply to message #214240] Mon, 15 January 2007 09:16 ebrian Messages: 2794Registered: April 2006 Senior Member I apologize, the value should indeed be NULL. How were you creating the new users? Were you trying to use the same passwords as in the old database? Report message to a moderator Re: Ora-28003 When updating user details

1:ORA-28003: password verification for the specified password failedORA-20002: Password length less than 4Cause of The problem:----------------------------------There is a password verify function assigned on the profile of the user. The http://exploreoracle.blogspot.com/2009/01/ora-28003-ora-20002-while-changing.html verify function does not allow to to change password to a and it specifies password length less than 4.Solution of The Problem:---------------------------------------Way 1:-----------Change the password as it satisfy the password verfify function. Suppose if function impose restriction password to length at least 4 characters, must have one number and one alphanumeric character and one special character then ora 28003 change the password as following,SQL> alter user shaik by "b!12";User altered.Way 2:----------------If you don't care about password verification function then you may disable the function.To do it first look for the user profile for which you get the error.SQL> select profile from dba_users where username='SHAIK';PROFILE------------------------------DEFAULTThen look for the assigned function of the intended profile.SQL> select RESOURCE_NAME,RESOURCE_TYPE,LIMIT from dba_profiles error ora 28003 where PROFILE='DEFAULT' and RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION';RESOURCE_NAME RESOURCE LIMIT-------------------------------- -------- ----------------------------------------PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTIONEither assigned another function of disable the verification function. You can disable it by,SQL> alter profile default limit PASSWORD_VERIFY_FUNCTION NULL;Profile altered.Now change the password.SQL> alter user shaik identified by a;User altered. Labels: ORA - Errors Posted by khaleel shaik at 10:30 PM 0 comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Labels Data Guard Data Pumping FAQ IMP EXP/RMAN iSQL ORA - Errors Ora Install Oracle Patch's RAC SCRIPT'S SQL TableSpace Tuning UNIX Blog Archive ▼ 2009 (268) ► 08/30 - 09/06 (3) ► 06/14 - 06/21 (2) ► 05/17 - 05/24 (12) ► 04/26 - 05/03 (3) ► 04/19 - 04/26 (6) ► 03/29 - 04/05 (8) ► 02/15 - 02/22 (1) ► 02/08 - 02/15 (4) ► 02/01 - 02/08 (4) ► 01/25 - 02/01 (23) ► 01/18 - 01/25 (23) ► 01/11 - 01/18 (36) ▼ 01/04 - 01/11 (143) Recover database after missing online redo logs an... If oracle unab