Though its not preferred, for simplicity sake, we keep username and password same for all those schema's and I had to reset password for bunch of schema's.
When I tried to reset password for a schema, I get an message say "ORA-28003: Password verification for the specified password failed", basically asking me to set up a complex password.
Workaround for this is to remove complex password check. You do this by changing your PROFILE.
When you query Profile, you could see "VERIFY_PASSWORD" set for the profile, and that is forcing a complex password.
To remove "VERIFY_PASSWORD" check, you need to run following
Alter profile DEFAULT Limit PASSWORD_VERIFY_FUNCTION NULL;
Once thats done, you will be able to reset back to easy password.
No comments:
Post a Comment