Oracle-密码过期、设置永不过期、修改密码、查询过期用户

查询过期用户

select username,account_status from dba_users where account_status like '%EXPIRED%' or account_status like '%LOCKED%';

修改密码

ALTER USER scott identified by tiger;

设置过期策略为永不过期

查看默认过期策略

一般是180天

select * from dba_profiles where resource_name = 'PASSWORD_LIFE_TIME'; 

修改为永不过期

 ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;