密码即将过期，密码策略加上后，不能改为原先密码，又不想变为别的
-
-
conn / as sysdba
-
--sho pdbs
-
--alter session set container=&1;
-
-
set lin 120
-
col username for a30
-
select username,account_status,expiry_date from dba_users where account_status='EXPIRED(GRACE)' order by 1;
-
-
-
set line 500 pages 100
-
select 'alter user ' ||su.name||' identified by values'||' '''||spare4||';' ||su.password||''';'
-
from sys.user$ su,dba_users du
-
where su.name=du.username and account_status like '%GRACE%';
-
执行生成的修改脚本即可
阅读(1519) | 评论(0) | 转发(0) |
