3.1.1.3.18 PartitionRoleMembers Table

The entries in the PartitionRoleMembers table represent partition role members.

Table identifier: {352131CD-E0FF-4C46-9675-C3808B249F69}

AuxiliaryGuid: None.

Defined in catalog version: 4.00 and 5.00.

Hidden bitness property: No.

Supported query templates:

Cell 1

Cell 2

PartitionIdentifier equals <A>.

RoleName equals <B>.

Primary key: PartitionIdentifier, RoleName, RoleMember.

Other referential constraints: There MUST exist a partition role with identical values of PartitionIdentifier and RoleName.

Write restrictions: Update MUST NOT be supported.

Add and remove MUST be supported if and only if the partition identified by PartitionIdentifier has the value "Y" for Changeable.

Cascade: None.

Populate: None.

Properties:

 Index (4.00/5.00)

 Property name

 Type

 Size

 Flags

 Meta

0

PartitionIdentifier

eDT_GUID

16

0x00000003

RO

1

RoleName

eDT_LPWSTR

variable

0x00000003

RO

2

RoleMember

eDT_LPWSTR

variable

0x00000003

RO

PartitionIdentifier: The PartitionIdentifier property of the partition role.

RoleName: The RoleName property of the partition role.

RoleMemberName: A SecurityPrincipalNameProperty (section 2.2.2.17) identifying the name of the security principal associated with the partition role identified by PartitionIdentifier and RoleName.<223>