SQL

oracle change password expiration policy

CREATE PROFILE SHORT_LIFE_PROFILE LIMIT
    PASSWORD_LIFE_TIME 1/24/60/60 		--> 1 second
    PASSWORD_GRACE_TIME 1/24; 			--> 1 hour

ALTER USER user_name PROFILE SHORT_LIFE_PROFILE;    -- Log on to refresh

SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME = 'user_name';