3.1.5.94.1 Site Membership Result Set

The Site Membership Result Set returns a list of all non-deleted users or domain groups registered with the specified site. The Site Membership Result Set MUST return zero rows if the site specified by @WebId has no members, otherwise it MUST contain one row for each member if @WebId matches an existing site within the site collection specified by @SiteId.

       tp_Id                          int,
       tp_SystemID                    varbinary(512),
       tp_Title                       nvarchar(255),
       tp_Login                       nvarchar(255),
       tp_Email                       nvarchar(255),
       tp_Notes                       nvarchar(1023),
       tp_SiteAdmin                   bit,
       tp_DomainGroup                 bit,
       tp_Flags                       int;

tp_ID: The user identifier (section 2.2.1.13) of the security principal.

tp_SystemID: The SystemID (section 2.2.1.12) of the security principal.

tp_Title: The display name of the security principal.

tp_Login: The login name of the security principal.

tp_Email: The email address of the security principal.

tp_Notes: A descriptive text associated with the security principal.

tp_SiteAdmin: Contains a bit flag set to 1 if the security principal is a site collection administrator. This value is set to 0 if the user is NOT a site collection administrator.

tp_DomainGroup: Contains a bit flag set to 1 if the security principal is a domain group. This value is set to 0 if the security principal is NOT for a domain group.

tp_Flags: A 4-byte integer bit mask determining the security principal's options as specified in UserInfo Flags (section 2.2.2.11).