Mega Code Archive

 
Categories / Oracle PLSQL / User Previliege
 

Creating a profile with the time period for locking the account

CREATE PROFILE test_profile LIMIT FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LOCK_TIME UNLIMITED