Principal Table

 

Topic Last Modified: 2011-02-03

The Principal table contains all principals, including users, folders, and groups.

Columns

Column Type Description

prinID

int, not null

Principal ID.

prinGuid

uuid, not null

Principal GUID. This is broadly used as an alternate primary key because its meaning crosses over into the Active Directory Domain Services (AD DS) space. (The GUID for a cached principal is equal to the corresponding Active Directory object GUID.)

prinUri

nvarchar (256), not null

Principal URI. The sip scheme is used for users, and ma-grp is used for almost everything else.

prinName

nvarchar (256)

Display name. Used only by user types.

prinCompanyName

nvarchar (256)

Company name. Used only by user types.

prinEmail

nvarchar (256)

Email. Used only by user types.

prinADPath

nvarchar (256)

Domain name of the Active Directory object that the principal is a cached version of. Can be Null for types that are not Active Directory objects (such as federated users, system users, and federated groups).

prinADUserPrincipalName

nvarchar (256)

User’s user principal name (UPN). Used only by regular user types.

prinDisabled

bit, not null

True if the principal is considered disabled. This is used when a user leaves the company or the user’s SIP capabilities are disabled.

prinTypeID

smallint, not null

Principal type (from PrincipalType table).

prinAllowedPermSet

bigint, not null

Principal user rights and permissions (as set in the Manage Users and User Groups Microsoft Lync Server 2010, Group Chat Admin Tool window) when prinUseInheritedPerms is False.

Primary bits:

  • 0: True if the principal can post files.

  • 1: True if the principal is an administrator with administrator rights and permissions to manage users and groups (in Manage Users and User Groups).

  • 2: True if the principal is an administrator with administrator rights and permissions to manage nodes (categories and chat rooms).

prinUseInheritedPerms

bit, not null

False if the principal has the user rights and permissions defined by prinAllowedPermSet.

True if the principal inherits the user rights and permissions from its groups, containers, and so on, in an additive manner.

prinAddedBy

int

Principal ID of the creator.

prinAddedOn

bigint, not null

Time stamp for the creation time.

prinUpdatedBy

int

ID of the principal that last updated this.

prinUpdatedOn

bigint, not null

Time stamp for the last update.

prinVerifiedOn

datetime, not null

Date and time of the last Active Directory Sync refresh for the principal.

Keys

Column Description

prinID

Primary key.

prinTypeID

Foreign key with lookup in PrincipalType.ptypeID table.