14.1 sp802_permission
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
A role can have a number of permissions; this table defines all of the permissions within the system.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| permission_id | number |  | |
| operation | varchar2(10) | | |
| property | varchar2(120) | |
Keys
primary key (permission_id)
unique (permission_id, operation, property)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| permission_id | Permission identifier. |
| operation | Operation(s) that the permission entitles a role to perform; chosen from the set CRUD (Create, Read, Update, Delete) or ALL. |
| property | Defines the object which the permission entitles a role to perform the operation(s) on, e.g. FRU.Team.Oper.SA. |