select username , profile from dba_users
查询密码过期策略
select * from dba_profiles s where s.profile='DEFAULT'
AND resource_name='PASSWORD_LIFE_TIME'
修改密码永不过期
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
select username , profile from dba_users
查询密码过期策略
select * from dba_profiles s where s.profile='DEFAULT'
AND resource_name='PASSWORD_LIFE_TIME'
修改密码永不过期
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED