ActivityCategorySecurity_vw


Description

Activity category security view providing a unified view of security permissions for activity categories by user and group. This view consolidates user-based and group-based permissions to determine effective access rights for activity categories, supporting security evaluation and permission management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkactivitycategoryid int 4 null

Activity category reference - Links to the activity category

userid int 4 null

User reference - User ID for permission evaluation

viewsecurity varchar 15 null

View permission - Effective view permission level for the user

Type varchar 5 null

Permission type - Source of permission (User or Group)

Relationships

View Definition