September 2007
Intermediate to advanced
600 pages
20h 21m
English
The UserRoles table (Table 5.9) defines user security roles used by secures applications. This table isn’t related to any of the other tables.
| Column | Data Type | Description and Size |
|---|---|---|
| UserRoleID | Numeric | Unique ID of user roles; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field) |
| UserRoleName | Text | User role name (title) |
| UserRoleFunction | Text | User role description |
The primary key for this table is the UserRoleID column.
This table contains no foreign keys.
Read now
Unlock full access