Show all Hide all
Deprecated in: 5.4.019
Maps Active Directory groups against roles and functions. Used by advanced single-sign on. The contents of this table are not deployed.
Add row: Allowed
Delete row: Allowed
Foreign key: Not allowed


Name Datatype Read Write Primary key Description
ADGroupID int Yes No Yes Primary key.
ADGroup varchar(500) Yes Yes No The name of the AD group to map. Must match the actual group's name. Case insensitive.

The same group may occur multiple times if you need to assign both role and functions to its members.
RoleID int Yes Yes No Role to give members of this group. If a user belongs to multiple groups he gets the one with the lowest sort order.

A user must always be assigned at least one role to be able to log in, even if you also use functions.
FunctionID int Yes Yes No Function to assign members of this group.

Any previous function mappings are deleted each time a user logs in.
SortOrder int Yes Yes No Sort order.