修改oracle 指定用户密码 不过期

(1) 查询用户所在的profile
select username,profile,account_status,expiry_date from dba_users WHERE username = 'test';
(2)查看profile 设置信息
select * from dba_profiles where profile = 'TEST_PROFILE' and RESOURCE_NAME = 'PASSWORD_LIFE_TIME';
(3)创建profile
create profile HNJHFJFL_PROFILE profile limit password_life_time unlimited;
(4)修改用户所在的profile
alter user test profile TEST_PROFILE;