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)

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.