【024】修改EA密码

永久修改EA密码

-- 设置密码123456:
update Base_User set Password=upper(substring(sys.fn_VarBinToHexStr(hashbytes('MD5', CAST('zgv9FQWbaNZ2iIhNej0+jA==' as varchar(50)) + convert(char(36),base_user.salt))),3,32)) 
where Code = 'EA'

临时修改EA密码

-- 先保存一下原来的EA密码
declare @Pwd nvarchar(50)
select @Pwd=Password from Base_User where Code = 'EA'
select @Pwd

-- 设置密码123456:
update Base_User set Password=upper(substring(sys.fn_VarBinToHexStr(hashbytes('MD5', CAST('zgv9FQWbaNZ2iIhNej0+jA==' as varchar(50)) + convert(char(36),base_user.salt))),3,32)) 
where Code = 'EA'

-- 用完之后还原
update Base_User set Password= @Pwd where Code = 'EA'

启用用户

-- 启用用户
update Base_User set IsAlive=1 where code='adminwc'