3.1.1.3.17 PartitionRoles Table
The entries in the PartitionRoles table represent partition roles, which are implementation-specific collections of users that can be associated with partitions.
Table identifier: {9D29E285-E24D-4096-98E1-44DBB2EAF7F0}
AuxiliaryGuid: None.
Defined in catalog version: 4.00 and 5.00.
Hidden bitness property: No.
Supported query templates:
|
Cell 1 |
|---|
|
PartitionIdentifier equals <A>. |
Primary key: PartitionIdentifier, RoleName.
Other referential constraints: There MUST exist a partition with an identical value of PartitionIdentifier.
Write restrictions: Add and remove MUST NOT be supported.
Update MUST be supported if and only if the partition identified by PartitionIdentifier has the value "Y" for Changeable.
Cascade: On removal of an entry, all entries in PartitionRoleMembers (section 3.1.1.3.18) table with identical values of PartitionIdentifier and RoleName MUST be removed.
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 |
Description |
eDT_LPWSTR |
variable |
0x00000000 |
RO |
PartitionIdentifier: The PartitionIdentifier of the partition associated with the role.
RoleName: A NameProperty (section 2.2.2.6) providing a human-readable name for the role.<221>
Description: If not null, a DescriptionProperty (section 2.2.2.7) providing a human-readable description of the role.<222>