fw group x link

Name

fw_group_x_link

Prefix

fgl

Group Item

Set Group Security

Initial Build

2006.02

Important! This table is deprecated. fw_group_security replaces its use within the netFORUM security framework.

The fw_group_x_link table stores Group Item Link Security records. The records in this table grant access to users in a security group to a particular Group Item Link. If a user belongs to a group, and that group has a record in this table for a particular Group Item Link, then that user will have access to that Group Item Link.

Columns

Name Description Datatype Notes
fgl_key Unique Key av_key  
fgl_grp_code Group Name nvarchar(50) The Security Group code
fgl_cgl_key Content Link Key av_key Foreign Key to the Group Item Link record
fgl_add_date Add Date av_date_small  
fgl_add_user Add User av_user  
fgl_change_date Change Date av_date_small  
fgl_change_user Change User av_user  
fgl_delete_flag Delete Flag av_delete_flag  
fgl_entity_key Entity Key av_key  

Parent Tables

Parent Table Parent Key Child Key Join
cm_group_item_link cgl_key fgl_cgl_key fgl_cgl_key = cgl_key
fw_group grp_code fgl_grp_code fgl_grp_code = grp_code