VPA Groups Use Case: Building Code List - Assigning VPA Groups to Users

In some cases, administrators have only one or two people with a specific VPA Group assignment. For instance, they may have only one CAD/BIM Manager per region. They would still wish to assign VPA Groups to organize the building responsibilities to each manager, but they want to do so on a per-user basis, as otherwise they would need to create a special role for each user.

Define the role

In the afm_roles table, use a single, common role for all CAD/BIM managers.

use_case_2_roles.png

Assign the role to users

In the afm_users table, assign this role to multiple users.

use_case_2_users.png

Map VPA Groups to users

In the afm_groupstousers table, assign one or more VPA Groups to each user.

use_case_2_group_to_users.png

Enter restrictions in the VPA Restrictions table (vpa_rest)

You use the same VPA Restrictions record entry regardless of whether the VPA Groups are assigned by Role, by User or both.

use_case_2_restrictions.png

Resulting SQL restriction clauses

See Use Case 1: VPA Use Case: Building Code List - Assigning VPA Groups to Roles