标题: Oracle 12c IDENTIFIED BY VALUES [打印本页] 作者: miss_puff 时间: 2018-11-22 10:15 标题: Oracle 12c IDENTIFIED BY VALUES 12c中，如果用户密码过期，且要指定为原来的密码，可通过查询sys.user$中的SPARE4列获取密文select name,spare4 from sys.user$;
alter user sztech identified by
values 'S:B822EA930D2C6D9BD45A5A85F2CFD4ED559B414F2D3B06C94C48ADBCC50B;T:A035224CCD5197626B771B4C8D13DAE3DFDE9D2E1DA3EE5F76BAE763B9F8D19C6618E376F23F268D1C2CF05939B25D2F55710180B544E0F5A4FC6428E6EACEB04F6C93D1F169039BC28DF6C4418195EC';