ALTER PROFILE SECURITY_VERIFY LIMIT PASSWORD_LIFE_TIME UNLIMITED;


ALTER PROFILE SECURITY_VERIFY LIMIT PASSWORD_GRACE_TIME UNLIMITED;


ALTER USER TEST IDENTIFIED BY 112233;

SELECT username,PROFILE FROM dba_users where username like 'TEST%';


SECURITY_VERIFY

select * from dba_users where username='TEST';