Share via

2.2.7.5 GroupMembership Table

  • Article

The GroupMembership Table stores a list of the principals that are members of each site group in a site collection. The GroupMembership Table is defined using T-SQL syntax, as follows.

 TABLE GroupMembership(
       SiteId                         uniqueidentifier   NOT NULL,
       GroupId                        int                NOT NULL,
       MemberId                       int                NOT NULL
 );

SiteId: The Site Collection Identifier (section 2.2.1.9) of the site collection containing the principals and site groups.

GroupId: The site group identifier of the site group that the principal specified by MemberId is a member of.

MemberId: The User Identifier (section 2.2.1.13) of a principal that is a member of the site group specified by GroupId.