Looking to create a business adapter which will import (add, update, or delete) Compliance Operators (table: ComplianceOperator) & respective tables that define the roles, permissions, groups, membership, & access in WebUI (examples listed in bottom of this post). The proposed solution is to populate a staging table that defines the access/groups a user belongs to.  For example, the staging table is populated based on Active Directory groups that designate what permissions a user should have in the FNMS Web UI. The goal here is to eliminate operational effort / manual tasks that consistently take place when, for example, a new stakeholder desires access to the tool, a new teammate joins, or someone leaves the team. I noticed there are stored procedures that appear to handle creation (add) of the admin user in the upgrade/install docs (~ ComplianceProcedures.sql); however, this appears to only work for initial creation of admin user. I was looking for a query/sp to supply to a business adapter, which would be executed on a schedule to audit & provision intended access for users (ComplianceOperator) in the FNMS Web UI. Any help in this space would be greatly appreciated. I would be more than happy to collaborate on a potential solution as I can imagine this would be a useful adapter for anyone implementing FlexNet Manager Suite. Again, the goal here is to eliminate operational effort / manual tasks that need to take place when a new stakeholder desires access to the tool, a new teammate joins, or someone leaves.  From digging through tutorials, learning modules, & schema references, I've created Related_Helper_Queries.sql (attached) & narrowed down a handful of tables that appear to be linked to user/role/ComplianceOperator access, which are: ComplianceOperator ComplianceOperatorTenant OperatorTenantSetting_MT GroupEx_MT (Note:  Default role IDs ~ groupId = 10,9,8,7,6 ~ Business Reporting Portal Admin, Web Service, View Only, Operator, Administrator) MemberEx_MT (Note: TargetTypeID = 16 = Operator) RoleRight_MT Tenant TBD Gaps (this is where I could use the most help): SQL query/queries that would fetch all the respective details for the default/generic roles & tables that come with FNMS out of the box Business adapter logic to map related tables that handle what access/roles/permissions/operators have in the FNMS UI or.. stored procedure to execute all Create, Read, Update, Delete (CRUD) operations required for this adapter - related query found in Related section (below)   Useful resources:  UsingFlexNetBusinessAdapters2019R1.pdf  (FNMS 2019 R1 On Prem) "The Link Operator - Role Object" (pg. 156-157) "The Operator Object" (pg. 162)  FNMSSchemaReference.pdf  (FNMS 2019 R1 On Prem) FlexNet Manager Suite Operations Class > Managing Users in FlexNet Manager  Related: Stored procedure to add initial admin account (from install > db create) ~/FlexNet Manager Suite Installer 2019 R1/FlexNet Manager Suite\Database\Partitioned\FlexNet Manager Platform\ComplianceProcedures.sql Changing a Service Account into an Interactive Account (Flexera Community > Forums) User vs. Account (Flexera Community > Forums)   Thank you for your time & I hope we can find a solution that will be useful to everyone. ... View more