1CREATE PROFILE SHORT_LIFE_PROFILE LIMIT
2 PASSWORD_LIFE_TIME 1/24/60/60 --> 1 second
3 PASSWORD_GRACE_TIME 1/24; --> 1 hour
4
5ALTER USER user_name PROFILE SHORT_LIFE_PROFILE; -- Log on to refresh
6
7SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME = 'user_name';