oracle 11g 密碼不過期、不限制錯誤次數設定

oracle 11g 密碼不過期、不限制錯誤次數設定

col username for a20
col profile for a40
SELECT username,PROFILE FROM dba_users;
select limit from  dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

SELECT LIMIT FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

FAILED_LOGIN_ATTEMPTS=》登入錯誤次數限制
PASSWORD_LIFE_TIME     =》密碼有效期限制