oracle 密码过期


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;

alter user SYSTEM identified by panku account unlock;

posted @ 2019-04-09 15:52  绿水青山777  阅读(80)  评论(0编辑  收藏  举报