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 :
Posted by at

7 comments:

  1. UnknownMay 5, 2016 at 6:11 AM

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

    ReplyDelete
  2. UnknownAugust 9, 2016 at 10:05 PM

    Thanks dear...problem resolved.

    ReplyDelete
  3. AnonymousNovember 30, 2016 at 8:08 AM

    Thanks very useful.

    ReplyDelete
  4. Rakesh (Raki)September 11, 2017 at 5:46 AM

    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. arvind toorpuSeptember 11, 2017 at 8:17 AM

    @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. Rakesh (Raki)September 11, 2017 at 10:19 AM

    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. arvind toorpuSeptember 12, 2017 at 8:12 AM

    @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

Subscribe to: Post Comments (Atom)