设置Oracle密码永不过期
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
--查询密码状态
select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
--查询密码状态
select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'