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.
‎Aug 30, 2020 10:26 PM
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
‎Aug 31, 2020 04:12 AM
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
‎Aug 31, 2020 04:12 AM
‎Aug 31, 2020 04:32 PM
It works perfectly. Thank you 🙂
‎Sep 01, 2020 03:53 PM