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';Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
