SOAP request:
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><SetMbSec xmlns="http://www.fsight.ru/PP.SOM.Som"><tMbSec xmlns=""> <id>S1!M</id>
</tMbSec>
<tArg xmlns=""><pattern> <users>Remove</users>
</pattern>
<meta><users><its><it> <k>197730</k>
<id>NEWREPOADMIN</id>
<n>NewRepoAdmin</n>
<vis>true</vis>
<type>User</type>
<sid> <sid>PS-1-197730</sid>
<type>User</type>
</sid>
<data> <isNT>false</isNT>
<isExternal>false</isExternal>
<isBuiltin>false</isBuiltin>
<user> <mustChangePasswordAtNextLogon>true</mustChangePasswordAtNextLogon>
<cannotChangePassword>false</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>true</manageDBGrants>
<maxLogonSessions>3</maxLogonSessions>
<lastLoginStamp>1899-12-30T00:00:00</lastLoginStamp>
<hasAccessToRepository>true</hasAccessToRepository>
<isAdmin>false</isAdmin>
<isIsa>false</isIsa>
<isRoled>false</isRoled>
<changePassStamp>2020-03-23T04:07:00</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>false</eternalPass>
<certificate />
</user>
</data>
</it>
</its>
</users>
</meta>
<metaGet><pattern> <users>Get</users>
</pattern>
</metaGet>
</tArg>
</SetMbSec>
</s:Body>
</s:Envelope>
SOAP response:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><SetMbSecResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><id xmlns=""> <id>S1!M</id>
</id>
<metaGet xmlns=""><id> <id>S1!M</id>
</id>
<meta><users><its><it> <k>2147483649</k>
<id>ADMIN</id>
<n>User</n>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-1</sid>
<type>User</type>
</sid>
<data> <desc />
<memberOf><its><it> <k>2147483649</k>
<id>ADMINISTRATORS</id>
<n>ADMINISTRATORS</n>
<vis>1</vis>
<type>Group</type>
<sid> <sid>PS-2-1</sid>
<type>Group</type>
</sid>
</it>
</its>
</memberOf>
<isNT>0</isNT>
<isExternal>0</isExternal>
<isBuiltin>1</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>2020-03-23T14:06:51.600</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>1</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2020-03-23T09:07:03.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>1</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>2147483646</k>
<id>FS\IVANOV.IVAN</id>
<n>Ivanov Ivan Ivanovich</n>
<vis>1</vis>
<type>User</type>
<sid> <sid>S-1-5-21-2210245889-1953428358-4221806923-1269</sid>
<type>User</type>
</sid>
<data><memberOf><its><it> <k>2147483649</k>
<id>ADMINISTRATORS</id>
<n>ADMINISTRATORS</n>
<vis>1</vis>
<type>Group</type>
<sid> <sid>PS-2-1</sid>
<type>Group</type>
</sid>
</it>
</its>
</memberOf>
<isNT>1</isNT>
<isExternal>1</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>2019-03-21T16:05:39.630</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2018-04-04T05:24:46.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>0</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>173284</k>
<id>INS_FORM</id>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-173284</sid>
<type>User</type>
</sid>
<data><memberOf> <its />
</memberOf>
<isNT>0</isNT>
<isExternal>0</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>1</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>1899-12-30T00:00:00.000</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2019-12-25T05:18:35.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>0</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>29500</k>
<id>WAREHOUSE_ISA</id>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-29500</sid>
<type>User</type>
</sid>
<data><memberOf> <its />
</memberOf>
<isNT>0</isNT>
<isExternal>0</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>2015-12-29T17:36:03.743</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2015-12-28T12:48:50.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>0</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>20798</k>
<id>SIDOROV_IV</id>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-20798</sid>
<type>User</type>
</sid>
<data><memberOf><its><it> <k>2147483650</k>
<id>USERS</id>
<n>USERS</n>
<vis>1</vis>
<type>Group</type>
<sid> <sid>PS-2-2</sid>
<type>Group</type>
</sid>
</it>
</its>
</memberOf>
<isNT>0</isNT>
<isExternal>1</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>2018-05-04T16:56:01.790</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2016-11-07T09:55:24.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>0</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>158195</k>
<id>TESTUSER</id>
<n>TESTUSER</n>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-158195</sid>
<type>User</type>
</sid>
<data> <desc>TESTUSER</desc>
<memberOf> <its />
</memberOf>
<isNT>0</isNT>
<isExternal>0</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>1</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>1899-12-30T00:00:00.000</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2019-07-19T05:57:50.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>1</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>105159</k>
<id>USER1234</id>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-105159</sid>
<type>User</type>
</sid>
<data><memberOf> <its />
</memberOf>
<isNT>0</isNT>
<isExternal>0</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>1899-12-30T00:00:00.000</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2018-08-31T09:49:02.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>0</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>35005</k>
<id>USER123456789</id>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-35005</sid>
<type>User</type>
</sid>
<data> <desc>USER123456789 / USER123456789</desc>
<memberOf><its><it> <k>2147483649</k>
<id>ADMINISTRATORS</id>
<n>ADMINISTRATORS</n>
<vis>1</vis>
<type>Group</type>
<sid> <sid>PS-2-1</sid>
<type>Group</type>
</sid>
</it>
</its>
</memberOf>
<isNT>0</isNT>
<isExternal>0</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>2017-09-13T12:42:15.000</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2016-06-23T06:49:07.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>0</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>105163</k>
<id>USER_1234</id>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-105163</sid>
<type>User</type>
</sid>
<data><memberOf><its><it> <k>2147483649</k>
<id>ADMINISTRATORS</id>
<n>ADMINISTRATORS</n>
<vis>1</vis>
<type>Group</type>
<sid> <sid>PS-2-1</sid>
<type>Group</type>
</sid>
</it>
<it> <k>144122</k>
<id>BPM_ALL_USERS</id>
<n>BPM_ALL_USERS</n>
<vis>1</vis>
<type>Group</type>
<sid> <sid>PS-1-144122</sid>
<type>Group</type>
</sid>
</it>
</its>
</memberOf>
<isNT>0</isNT>
<isExternal>0</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>2020-03-06T10:24:31.680</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2020-03-05T08:16:42.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>0</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>67467</k>
<id>USER_ANN</id>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-67467</sid>
<type>User</type>
</sid>
<data><memberOf><its><it> <k>2147483649</k>
<id>ADMINISTRATORS</id>
<n>ADMINISTRATORS</n>
<vis>1</vis>
<type>Group</type>
<sid> <sid>PS-2-1</sid>
<type>Group</type>
</sid>
</it>
</its>
</memberOf>
<isNT>0</isNT>
<isExternal>0</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>0</maxLogonSessions>
<lastLoginStamp>2019-04-09T11:53:11.770</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2019-04-09T06:53:02.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>0</eternalPass>
<certificate />
</user>
</data>
</it>
<it> <k>197730</k>
<id>NEWREPOADMIN</id>
<n>NewRepoAdmin</n>
<vis>1</vis>
<type>User</type>
<sid> <sid>PS-1-197730</sid>
<type>User</type>
</sid>
<data><memberOf><its><it> <k>2147483649</k>
<id>ADMINISTRATORS</id>
<n>ADMINISTRATORS</n>
<vis>1</vis>
<type>Group</type>
<sid> <sid>PS-2-1</sid>
<type>Group</type>
</sid>
</it>
</its>
</memberOf>
<isNT>0</isNT>
<isExternal>0</isExternal>
<isBuiltin>0</isBuiltin>
<user> <mustChangePasswordAtNextLogon>0</mustChangePasswordAtNextLogon>
<cannotChangePassword>0</cannotChangePassword>
<lockedState>NotLocked</lockedState>
<manageDBGrants>1</manageDBGrants>
<maxLogonSessions>3</maxLogonSessions>
<lastLoginStamp>1899-12-30T00:00:00.000</lastLoginStamp>
<hasAccessToRepository>1</hasAccessToRepository>
<isAdmin>0</isAdmin>
<isIsa>0</isIsa>
<isRoled>0</isRoled>
<changePassStamp>2020-03-23T09:07:03.000</changePassStamp>
<autoRun />
<temporaryAge>0</temporaryAge>
<eternalPass>0</eternalPass>
<certificate />
</user>
</data>
</it>
</its>
</users>
<bisearchEnable>Full</bisearchEnable>
<apply><onCredentialsRequired><logonParams> <descr>Enter user name and password of the user who has permissions to create tables in the 'Database' database</descr>
<realm>OBJ21909</realm>
<toAdmin>1</toAdmin>
<logonData> <driver>MSSQL2012</driver>
<server>v-nrspo-mssql.dev.fs.fsight.world</server>
<database>Warehouse</database>
</logonData>
</logonParams>
</onCredentialsRequired>
</apply>
</meta>
</metaGet>
</SetMbSecResult>
</soapenv:Body>
</soapenv:Envelope>
JSON request:
{
"SetMbSec" :
{
"tMbSec" :
{
"id" : "S1!M"
},
"tArg" :
{
"pattern" :
{
"users" : "Remove"
},
"meta" :
{
"users" :
{
"its" :
{
"it" :
[
{
"k" : "197730",
"id" : "NEWREPOADMIN",
"n" : "NewRepoAdmin",
"vis" : "true",
"type" : "User",
"sid" :
{
"sid" : "PS-1-197730",
"type" : "User"
},
"data" :
{
"isNT" : "false",
"isExternal" : "false",
"isBuiltin" : "false",
"user" :
{
"mustChangePasswordAtNextLogon" : "true",
"cannotChangePassword" : "false",
"lockedState" : "NotLocked",
"manageDBGrants" : "true",
"maxLogonSessions" : "3",
"lastLoginStamp" : "1899-12-30T00:00:00",
"hasAccessToRepository" : "true",
"isAdmin" : "false",
"isIsa" : "false",
"isRoled" : "false",
"changePassStamp" : "2020-03-23T04:07:00",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "false",
"certificate" : ""
}
}
}
]
}
}
},
"metaGet" :
{
"pattern" :
{
"users" : "Get"
}
}
}
}
}
JSON response:
{
"SetMbSecResult" :
{
"id" :
{
"id" : "S1!M"
},
"metaGet" :
{
"id" :
{
"id" : "S1!M"
},
"meta" :
{
"users" :
{
"its" :
{
"it" :
[
{
"k" : "2147483649",
"id" : "ADMIN",
"n" : "User",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-1",
"type" : "User"
},
"data" :
{
"desc" : " ",
"memberOf" :
{
"its" :
{
"it" :
[
{
"k" : "2147483649",
"id" : "ADMINISTRATORS",
"n" : "ADMINISTRATORS",
"vis" : "1",
"type" : "Group",
"sid" :
{
"sid" : "PS-2-1",
"type" : "Group"
}
}
]
}
},
"isNT" : "0",
"isExternal" : "0",
"isBuiltin" : "1",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "2020-03-23T14:06:51.600",
"hasAccessToRepository" : "1",
"isAdmin" : "1",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2020-03-23T09:07:03.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "1",
"certificate" : ""
}
}
},
{
"k" : "2147483646",
"id" : "FS\IVANOV.IVAN",
"n" : "Ivanov Ivan Ivanovich",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "S-1-5-21-2210245889-1953428358-4221806923-1269",
"type" : "User"
},
"data" :
{
"memberOf" :
{
"its" :
{
"it" :
[
{
"k" : "2147483649",
"id" : "ADMINISTRATORS",
"n" : "ADMINISTRATORS",
"vis" : "1",
"type" : "Group",
"sid" :
{
"sid" : "PS-2-1",
"type" : "Group"
}
}
]
}
},
"isNT" : "1",
"isExternal" : "1",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "2019-03-21T16:05:39.630",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2018-04-04T05:24:46.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "0",
"certificate" : ""
}
}
},
{
"k" : "173284",
"id" : "INS_FORM",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-173284",
"type" : "User"
},
"data" :
{
"memberOf" :
{
"its" : ""
},
"isNT" : "0",
"isExternal" : "0",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "1",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "1899-12-30T00:00:00.000",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2019-12-25T05:18:35.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "0",
"certificate" : ""
}
}
},
{
"k" : "29500",
"id" : "WAREHOUSE_ISA",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-29500",
"type" : "User"
},
"data" :
{
"memberOf" :
{
"its" : ""
},
"isNT" : "0",
"isExternal" : "0",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "2015-12-29T17:36:03.743",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2015-12-28T12:48:50.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "0",
"certificate" : ""
}
}
},
{
"k" : "20798",
"id" : "SIDOROV_IV",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-20798",
"type" : "User"
},
"data" :
{
"memberOf" :
{
"its" :
{
"it" :
[
{
"k" : "2147483650",
"id" : "USERS",
"n" : "USERS",
"vis" : "1",
"type" : "Group",
"sid" :
{
"sid" : "PS-2-2",
"type" : "Group"
}
}
]
}
},
"isNT" : "0",
"isExternal" : "1",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "2018-05-04T16:56:01.790",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2016-11-07T09:55:24.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "0",
"certificate" : ""
}
}
},
{
"k" : "158195",
"id" : "TESTUSER",
"n" : "TESTUSER",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-158195",
"type" : "User"
},
"data" :
{
"desc" : "TESTUSER",
"memberOf" :
{
"its" : ""
},
"isNT" : "0",
"isExternal" : "0",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "1",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "1899-12-30T00:00:00.000",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2019-07-19T05:57:50.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "1",
"certificate" : ""
}
}
},
{
"k" : "105159",
"id" : "USER1234",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-105159",
"type" : "User"
},
"data" :
{
"memberOf" :
{
"its" : ""
},
"isNT" : "0",
"isExternal" : "0",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "1899-12-30T00:00:00.000",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2018-08-31T09:49:02.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "0",
"certificate" : ""
}
}
},
{
"k" : "35005",
"id" : "USER123456789",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-35005",
"type" : "User"
},
"data" :
{
"desc" : "USER123456789 \/ USER123456789",
"memberOf" :
{
"its" :
{
"it" :
[
{
"k" : "2147483649",
"id" : "ADMINISTRATORS",
"n" : "ADMINISTRATORS",
"vis" : "1",
"type" : "Group",
"sid" :
{
"sid" : "PS-2-1",
"type" : "Group"
}
}
]
}
},
"isNT" : "0",
"isExternal" : "0",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "2017-09-13T12:42:15.000",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2016-06-23T06:49:07.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "0",
"certificate" : ""
}
}
},
{
"k" : "105163",
"id" : "USER_1234",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-105163",
"type" : "User"
},
"data" :
{
"memberOf" :
{
"its" :
{
"it" :
[
{
"k" : "2147483649",
"id" : "ADMINISTRATORS",
"n" : "ADMINISTRATORS",
"vis" : "1",
"type" : "Group",
"sid" :
{
"sid" : "PS-2-1",
"type" : "Group"
}
},
{
"k" : "144122",
"id" : "BPM_ALL_USERS",
"n" : "BPM_ALL_USERS",
"vis" : "1",
"type" : "Group",
"sid" :
{
"sid" : "PS-1-144122",
"type" : "Group"
}
}
]
}
},
"isNT" : "0",
"isExternal" : "0",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "2020-03-06T10:24:31.680",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2020-03-05T08:16:42.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "0",
"certificate" : ""
}
}
},
{
"k" : "67467",
"id" : "USER_ANN",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-67467",
"type" : "User"
},
"data" :
{
"memberOf" :
{
"its" :
{
"it" :
[
{
"k" : "2147483649",
"id" : "ADMINISTRATORS",
"n" : "ADMINISTRATORS",
"vis" : "1",
"type" : "Group",
"sid" :
{
"sid" : "PS-2-1",
"type" : "Group"
}
}
]
}
},
"isNT" : "0",
"isExternal" : "0",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "0",
"lastLoginStamp" : "2019-04-09T11:53:11.770",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2019-04-09T06:53:02.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "0",
"certificate" : ""
}
}
},
{
"k" : "197730",
"id" : "NEWREPOADMIN",
"n" : "NewRepoAdmin",
"vis" : "1",
"type" : "User",
"sid" :
{
"sid" : "PS-1-197730",
"type" : "User"
},
"data" :
{
"memberOf" :
{
"its" :
{
"it" :
[
{
"k" : "2147483649",
"id" : "ADMINISTRATORS",
"n" : "ADMINISTRATORS",
"vis" : "1",
"type" : "Group",
"sid" :
{
"sid" : "PS-2-1",
"type" : "Group"
}
}
]
}
},
"isNT" : "0",
"isExternal" : "0",
"isBuiltin" : "0",
"user" :
{
"mustChangePasswordAtNextLogon" : "0",
"cannotChangePassword" : "0",
"lockedState" : "NotLocked",
"manageDBGrants" : "1",
"maxLogonSessions" : "3",
"lastLoginStamp" : "1899-12-30T00:00:00.000",
"hasAccessToRepository" : "1",
"isAdmin" : "0",
"isIsa" : "0",
"isRoled" : "0",
"changePassStamp" : "2020-03-23T09:07:03.000",
"autoRun" : "",
"temporaryAge" : "0",
"eternalPass" : "0",
"certificate" : ""
}
}
}
]
}
},
"bisearchEnable" : "Full",
"apply" :
{
"onCredentialsRequired" :
{
"logonParams" :
{
"descr" : "Enter user name and password of the user who has permissions to create tables in the 'Database' database",
"realm" : "OBJ21909",
"toAdmin" : "1",
"logonData" :
{
"driver" : "MSSQL2012",
"server" : "v-nrspo-mssql.dev.fs.fsight.world",
"database" : "Warehouse"
}
}
}
}
}
}
}
}
public static SetMbSecResult DeleteUser(string mb, MbSubject user)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var setMbSec = new SetMbSec()
{
tArg = new SetMbSecArg()
{
//Operation execution pattern
pattern = new MbSecMdPattern()
{
users = ListOperation.Remove,
},
//Metadata that contain description of deleted user
meta = new MbSecMd()
{
users = new MbSubjects()
{
its = new MbSubject[1]
{
user
}
}
},
//Parameters for updating users list after operation execution
metaGet = new GetMbSecArg()
{
pattern = new MbSecMdPattern()
{
users = ListOperation.Get
}
}
},
//Repository moniker
tMbSec = new MbId() { id = mb }
};
//Delete user
var result = somClient.SetMbSec(setMbSec);
return result;
}