ActivityCategorySecurityFiltered_vw


Description

Filtered activity category security view providing the highest effective security permissions for each user-category combination. This view resolves conflicts between user-based and group-based permissions by selecting the maximum permission level, ensuring users receive the highest access rights available.

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

Effective view permission - Highest view permission level available to the user

Relationships

View Definition