i am tring to make my own report using SQL,
i want to show Security Namespace And Action Avalible for each Role.
example report that i want
user: “ABC”
NameSpace: Metadata Security Group
and then all the “Allow”, “Not Allow”, “Denied”
like- Read, Live, Playback etc
thank your in advance
As the SQL database might change from release to release, so we do not provide support on accessing it directly.
As Rie mentions, we do not provide support on the SQL database schemas. Instead, you can use Configuration API to get information about the available security namespaces and the attributes for each namespace.
If you’re not comfortable writing code in C# or making SOAP API calls to the management server, you might like to use the MilestonePSTools PowerShell module and specifically the Get-VmsRoleOverallSecurity cmdlet to get this information. It isn’t a TSQL query but it uses our MIP SDK which is supported.