Friday, June 22, 2012

disable password verify function in oracle

ISSUE:
You may fail to run some oracle provided sql scripts because of user creation failure. the creation failure is because provided password didnt' pass verify function.

CAUSE:
default password provided in oracle script doesn't satisfy your password verify function in default profile

SOLUTION:
alter profile default limit password_verify_function null;
run the script
alter profile default limit password_verify_function your-password-verify-function-name ;

reference;
http://www.dbapool.com/forumthread/topic_1140.html

No comments:

Post a Comment