Pages

Wednesday, June 19, 2013

disable password verify function in oracle

Password verify function can be disabled by setting it to null.


To make the password more complex most DBA's set the complexity to  oracle provided package.As default password complexity provided in oracle script doesn't satisfy your organizations requirements.

SOLUTION:


alter profile default limit password_verify_function null;
To Enable it back :

4 comments :

  1. Thank you so much! It really helped me today! Thankful.

    ReplyDelete
  2. Thanks dear...problem resolved.

    ReplyDelete
  3. Thanks very useful.

    ReplyDelete