Topic Last Modified: 2012-09-12

tblPrincipalType contains principal types to categorize what is in the tblPrincipal table.

Columns

Column Type Description

ptypeID

smallint, not null

Principal type ID.

ptypeDesc

nvarchar (256), not null

Description of the type.

ptypeIsSystemUser

bit, not null

True if the type corresponds to the principals that are used for internal purposes.

ptypeIsUser

bit, not null

True if the type is a user type.

Key

Column Description

ptypeID

Primary key.

Principal Values

ID Role Description User

1

Any

Generic principal with no known type. Not used in tblPrincipal table.

2

AnyUser

Generic principal of user type. Not used in tblPrincipal table.

Yes

3

AnyGroup

Generic principal with group semantic. Not used in tblPrincipal table.

4

SystemUser

Principal used internally by Persistent Chat Server.

5

User

Regular user.

Yes

8

DC

Active Directory Domain Services domain controller.

9

Group

Active Directory security group.

10

Folder

Active Directory container or organizational unit.

See Also