备份当前用户密码

11g 备份当前DHW用户密码

select sqltext from ( select name, 'alter user '||name||' identified by values '''||password||''';' sqltext from
user$ where spare4 is null and password is not null union select name, 'alter user '||name||' identified by values '''||spare4||';'||password||''';'
sqltext from user$ where spare4 is not null and password is not null ) where name ='DHW';


SQLTEXT
-----------------------------------------------------------------------------------------------------------------------
alter user DHW identified by values 'S:22F5C13C8E4360B91B07DE167301521E920B5860F61C1309B5787FE28ADE;29993640B77C2E30';

19c 备份当前C##DHW用户密码

select sqltext from ( select name, 'alter user '||name||' identified by values '''||password||''';' sqltext from
user$ where spare4 is null and password is not null union select name, 'alter user '||name||' identified by values '''||spare4||';'||password||''';'
sqltext from user$ where spare4 is not null and password is not null union select name, 'alter user '||name||' identified by values '''||spare4||''';'
sqltext from user$ where spare4 is not null and password is null ) where name ='C##DHW';

SQLTEXT
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------