To disable password expiry for Oracle accounts find whihc profile is in use and then change the default timeout on the profile. If the users are already expired and locked the password must be reset and the account unlocked.
select * from dba_users; -- find the users and which profile they use
-- change the DEFAULT profile to not expire
ALTER PROFILE DEFAULT LIMIT
PASSWORD_LIFE_TIME UNLIMITED;
-- could also add FAILED_LOGIN_ATTEMPTS UNLIMITED
No comments:
Post a Comment