sp802_permission
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
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. |