The modUserRoles table stores the information that associates a user's SAMAccountName with a role for the team solution.
This information is updated during User Directory synchronization of the modUserList table in the modSystem database. The data in this table is used by the security components of the team solution to resolve role membership locally on the server when either online or offline.
The modUserRoles database table contains a number of columns used by the team solutions. The following table lists those columns and their data types and provides a brief description of each.
| Column | Data type | Description |
| SAMAccountName | nvarchar(64) | Windows NT domain and user name. |
| RoleName | nvarchar(128) | Name of the role to which the user belongs. |
| rowguid | uniqueidentfier | Unique identifier used for user roles. |