sp103_activity_permissions

This table is used to define what types of activity can be created by each type of user.

Table Definition

Field	Type	Default
profile	varchar2(10)
activity_type	number(2)
read	number(1)	1
write	number(1)

primary key (profile, activity_type)

foreign key (profile) references sp084_user_profiles(profile)

foreign key (activity_type) references sp105_activity_types (activity_type)

Field	Description
profile	A string denoting the user role:
activity_type	A number identifying the activity type
read	This column should not be used (though the Gantt does currently retrieve it, hence the not null constraint).
write	A value of 0 indicates that users of the type specified by PROFILE cannot create or modify activities of type ACTIVITY_TYPE; a value of 1 indicates that they can.