SELECT username,PROFILE FROM dba_users;
select s.* from dba_profiles s where profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
--【1】修改为365天:
alter profile default limit password_life_time 365;
--【2】修改为无限制:
alter profile default limit password_life_time unlimited;
select s.* from dba_profiles s where profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
--【1】修改为365天:
alter profile default limit password_life_time 365;
--【2】修改为无限制:
alter profile default limit password_life_time unlimited;