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';