cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Query FNMS user entitlements

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.

(1) Solution
mfranz
By Level 17 Champion
Level 17 Champion

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

View solution in original post

(3) Replies
mfranz
By Level 17 Champion
Level 17 Champion

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

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

It works perfectly. Thank you 🙂