14.1 sp214_application_permissions

This table specifies the level of access provided for each user profile.

Table Definition

Field	Type	Default	Nullable
profile	varchar2(10)
operation	varchar2(30)
privilege	varchar2(5)
default_privilege	varchar2(5)

primary key (profile, function)

foreign key (profile) references 14.1 sp084_user_profiles(profile)

Field	Description
profile	User's profile.
operation	Function / window name
privilege	Character string indicating privileges granted with respect to the specified function/window and the user's own responsibility unit or work location (as identified in sp088). The string may contain one or more of the following characters: I - Insert; new records may be created D - Delete; records may be deleted M - Modify; records may be updated V - View; records may be viewed S - Select; records may be selected (in the user interface)
default_privilege	Character string indicating privileges granted with respect to the specified function/window and responsibility units or work locations other than the user's own. The format of the string is as described above for privilege.