SAP用户帐号密码通过一个已知帐号密码去修改
SAP用户帐号密码通过一个已知帐号密码去修改
由于存在HASH,所以需要将多个字段同步修改,否则仍然会报密码错误。
经测试,需修改以下字段。
update sapqas.usr02 set BCODE= (select BCODE from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set PWDSALTEDHASH = (select PWDSALTEDHASH from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set PASSCODE= (select PASSCODE from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set PWDLOCKDATE= (select PWDLOCKDATE from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set UFLAG = (select UFLAG from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set ERDAT= (select ERDAT from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set TRDAT = (select TRDAT from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set LTIME= (select LTIME from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set PWDLGNDATE= (select PWDLGNDATE from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
经多方测试最终只需要同步以下三个字段即可
update sapqas.usr02 set pwdchgdate = (select pwdchgdate from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set pwdsetdate = (select pwdsetdate from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
update sapqas.usr02 set PWDSALTEDHASH = (select PWDSALTEDHASH from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
最终代码简化为:
update sapqas.usr02 set (pwdchgdate,pwdsetdate,PWDSALTEDHASH) = (select pwdchgdate,pwdsetdate,PWDSALTEDHASH from sapqas.usr02 where mandt = 600 and bname = 'TEST' ) where mandt = 550 and bname = 'TEST'
post SAP-Garson
原文链接:https://blog.csdn.net/qq_49301430/article/details/124923879文章来自于网络,如果侵犯了您的权益,请联系站长删除!