The `rbac_default_permissions` table
This table maps account_access.gmlevel security levels to default RBAC roles. When a player logs in, their security level determines which role they receive automatically.
For a system overview, see RBAC.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| secId | INT | UNSIGNED | PRI | NO | Security Level id | ||
| permissionId | INT | UNSIGNED | PRI | NO | Permission id | ||
| realmId | INT | SIGNED | PRI | NO | -1 | Realm Id, -1 means all |
The permissionId field has a foreign key to rbac_permissions.id.
Description of the fields
The security level from account_access.gmlevel.
The RBAC permission (role) to grant by default for this security level. The default assignments are:
| secId | permissionId | Role |
|---|---|---|
| 0 | 195 | Player |
| 1 | 194 | Moderator |
| 2 | 193 | Gamemaster |
| 3 | 192 | Administrator |
Because roles chain through rbac_linked_permissions, granting Administrator (192) automatically includes Gamemaster, Moderator, and Player permissions.
The realm ID this default applies to. Use -1 to apply to all realms.