...
Column Name | Data Type | Description |
|---|---|---|
Id | int | (Auto) Unique Id |
Username | varchar(200) | The username of the individual (without with domain if used) who is assigned one or more configuration access roles. |
IsConfigurationAdministrator | bit | 1=true, 0=false. True allows this user to see and use ALL administration menus and pages as shown here. |
IsDeviceManager (This field is created incorrectly in v1.1 and previous versions. This field should be IsUserManager) | bit | 1=true, 0=false. True allows this user to see and use ONLY the Users administration menu item and page as shown here. |
Example Username with domain: ACME\ROADRUNNER
Example SQL to add a user (usermanager01) for User administration only:
...