ej_role Table (323)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Define access rights, memberships and other properties for role user members
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| name | This is the name of the role | String(255) | ● |
| use_user_group | Override user user group with role | Bool | ● |
| user_group | The group this user is member of | FK hierarchy | |
| access_mask | Access mask for users using this role | Int | ● |
| access_values | Access values for users using this role | Int | ● |
| use_categories | Override user categories with role categories | Bool | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| user_group | FK | Index |
Relationships
| Table | Description |
|---|---|
| hierarchy | This table contains folders used to group the extra tables in the system. |
| role_category | Category membership associated with a role |
| role_element | Profiles associated with a role |
| role_member | Users linked to a role. Deprecated. |
| role_workflow | Knowledge base workflow access rights associated with a role |
Replication Flags
- None
Security Flags
- No access control via user's Role.