I'm playing with automatically granting permissions to SSRS users using ReportServer.dbo.SetPolicy stored procedure and I'm stuck with updating @XmlPolicy field which contains the following:
我正在使用ReportServer.dbo.SetPolicy存储过程自动向SSRS用户授予权限，而我仍然坚持更新@XmlPolicy字段，其中包含以下内容：
@XmlPolicy = 'BUILTIN\AdministratorsAQIAAAAAAAUgAAAAIAIAAA==Content Manager'
@XmlPolicy ='BUILTIN \ AdministratorsAQIAAAAAAAUgAAAAIAIAAA == Content Manager'
The GroupUserId above is obviously the SID of BUILTIN\Administrators account which is 0x01020000000000052000000020020000.
上面的GroupUserId显然是BUILTIN \ Administrators帐户的SID，即0x01020000000000052000000020020000。
The question is how can I convert (encode) 0x01020000000000052000000020020000 to the AQIAAAAAAAUgAAAAIAIAAA== format?
问题是我如何将（编码）0x01020000000000052000000020020000转换为AQIAAAAAAAAUAAAAAIAAAIAAA = A / A格式？
Or is there a better way to do this? Thank you.
或者有更好的方法吗？谢谢。
1 个解决方案
#1
1
"AQIAAAAAAAUgAAAAIAIAAA==" is just the binary string 01 02 00 00 00 00 00 05 20 00 00 00 20 02 00 00 encoded in Base64.
“AQIAAAAAAAUgAAAAIAIAAA ==”只是在Base64中编码的二进制字符串01 02 00 00 00 00 00 05 20 00 00 00 20 02 00 00。
#1
1
"AQIAAAAAAAUgAAAAIAIAAA==" is just the binary string 01 02 00 00 00 00 00 05 20 00 00 00 20 02 00 00 encoded in Base64.
“AQIAAAAAAAUgAAAAIAIAAA ==”只是在Base64中编码的二进制字符串01 02 00 00 00 00 00 05 20 00 00 00 20 02 00 00。