Tuesday, 25 December 2012

disable password_verify_function

Sometimes user getting locked again and again after running some procedure or function , then in that case either disable  password_verify_function or alter profile or unlock the user by providing password manually .


select * from dba_profiles;

select * from dba_users where USERNAME like '<USERNAME>';

ALTER PROFILE DEFAULT limit PASSWORD_GRACE_TIME unlimited;


to disable password_verify_function:-


SQL> ALTER PROFILE DEFAULT limit password_verify_function null;


SQL> select profile from dba_users where username='<user_name>';


SQL> select RESOURCE_NAME,RESOURCE_TYPE,LIMIT FROM DBA_PROFILES WHERE PROFILE='<PROFILE_NAME>' AND RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION';


SQL>
ALTER PROFILE <PROFILE_NAME> LIMIT PASSWORD_VERIFY_FUNCTION NULL;

Profile altered.


SQL> alter user <username> identified by <password> account unlock;

User altered.

No comments:

Post a Comment