Query FNMS user entitlements

[snorroy]

Our User Access Management system would like to query the FNMS database to retrieve the list of users with access to FNMS, as well as associated privileges (user, operator, admin).

Has anyone done that before or knows what table(s) to query to access that information?

Is there a FNMS database schema available which we can use to work out how to do that?

Thanks.

[mfranz · Accepted solution]

Hi,

This is mapping Compliance Operators to Roles:

USE FNMSCompliance

SELECT
	co.OperatorLogin
	,ge.GroupCN Role
FROM MemberEx me
JOIN ComplianceOperator co
	ON me.TargetID = co.ComplianceOperatorID
		AND me.TargetTypeID = 16 -- ComplianceOperator
JOIN GroupEx ge
	ON me.GroupID = ge.GroupID

If you need the specific rights, you'll have too look into the following tables:

SELECT * FROM RoleRight
SELECT * FROM ActionClass
SELECT * FROM Resource

Best regards,

Markward

[snorroy]

Thank you for that. We'll give it a try and I'll let you know how it goes.

[snorroy]

It works perfectly. Thank you 🙂