私有云在有K3DBConfiger前缀的数据库右键执行以下update语句，可将用户密码重置为888888
--------------------------------------------------------------------------------------------
Update T_SEC_USER Set FPASSWORD =
'75645add0e41bebf3e377285d3a8e47ec87a8800ee0652cc7071b9cd3cea78d4'
Where FNAME = 'Administrator'
--------------------------------------------------------------------------------------------
--------或直接复制以下语句可在任意数据库直接执行-------
declare @database Nvarchar(500)
declare @sql Nvarchar(500)
Set @database = (Select top 1 name From SYS.DATABASES Where name like '%K3DBConfiger%')
Set @sql = 'Update ' + @database + '..'+'T_SEC_USER Set FPASSWORD = ' + '''75645add0e41bebf3e377285d3a8e47ec87a8800ee0652cc7071b9cd3cea78d4''' + ' Where FNAME = ' + '''Administrator'''
Execute sp_executesql @sql
SQLQuery.zip(0.41KB)
赞 35
打赏推荐阅读