3.1.1.3.10 RoleMembers Table

The entries in the RoleMembers table represent role members.

Table identifier: {CD331D10-C739-11D1-9D35-006008B0E5CA}

AuxiliaryGuid: None.

Defined in catalog version: All catalog versions.

Prerequisites: None.

Hidden bitness property: No.

Supported query templates:

Cell 1

Cell 2

ConglomerationIdentifier equals <A>.

RoleName equals <B>.

Primary key: ConglomerationIdentifier, RoleName, RoleMemberName.

Other referential constraints: There MUST exist a role with identical values for ConglomerationIdentifier and RoleName.

Write restrictions: Update MUST NOT be supported.

Add and remove MUST be supported if and only if:

  • The conglomeration identified by ConglomerationIdentifier has the value "Y" for Changeable.

  • Catalog version 4.00 and catalog version 5.00: The partition containing the conglomeration identified by ConglomerationIdentifier has the value "Y" for Changeable.

Cascade: None.

Populate: None.

Properties:

Index (3.00/4.00/5.00)

Property name

Type

Size

Flags

Meta

0

ConglomerationIdentifier

eDT_GUID

16

0x00000003

RO

1

RoleName

eDT_LPWSTR

variable

0x00000003

RO

2

RoleMemberName

eDT_LPWSTR

variable

0x00000003

RO

3

Internal1

eDT_BYTES

43

0x00000000

IN

In the previous table, internal property (marked with IN in the Meta column) MUST NOT be written to or interpreted by the client. The server's use of this property is implementation-specific because it does not affect interoperability.

ConglomerationIdentifier: The conglomeration identifier of the conglomeration associated with the role to which this role member belongs.

RoleName: A NameProperty (section 2.2.2.6) providing the human-readable name of the role to which this role member belongs.

RoleMemberName: A SecurityPrincipalNameProperty (section 2.2.2.17) identifying the security principal of the role member.<204>