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 :

8 comments :

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

    ReplyDelete
  2. Thanks dear...problem resolved.

    ReplyDelete
  3. Thanks very useful.

    ReplyDelete
  4. hi
    iam getting this error when resetting the function for password_verify_function.

    sql: alter profile USER_PROF limit password_verify_function sys.PASSWORD_VERIFY_FUNCTION

    ORA-02376: invalid or redundant resource

    ReplyDelete
  5. @Rakesh :
    I hope you are logged in as sys when running this sql. Also check if the function exists in your DB

    sql : SELECT owner,object_name FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION') and OBJECT_NAME='PASSWORD_VERIFY_FUNCTION';

    ReplyDelete
  6. Hi Arvind,
    I executed the above query from another user i.e 'OFS_UAT'.

    I removed the 'PASSWORD_VERIFY_FUNCTION' function with this query.
    SQL: alter profile USER_PROF limit password_verify_function NULL;

    And hence i want to replace it with original function from the same user but i got error 'ORA-02376'.

    ReplyDelete
  7. @Rakesh :

    sql : SELECT owner,object_name FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION') and OBJECT_NAME='PASSWORD_VERIFY_FUNCTION';

    You need to execute above query from sys or dba level user.First verify that func exists and then try to attach it to a profile using below.
    sql : alter profile USER_PROF limit password_verify_function PASSWORD_VERIFY_FUNCTION_NAME;

    Note: Remember PASSWORD_VERIFY_FUNCTION you want to use needs to be under SYS user cant be anywhere else. As it will a system level function. If you would like to use some other func then that function needs to be under sys user as well.

    If you are still having trouble reach out to me directly at arvindtoorpu.dba@gmail.com. I can help you!!

    ReplyDelete