oracle11g密码过期

sqlplus /nolog;

conn / as sysdba;

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

 ALTER USER WATER IDENTIFIED BY WATER ;

评论

1 楼 peijunlin2008 2015-01-29  

查看当前用户对应profile、对应密码周期

select * from dba_profiles where profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';