tblPrincipalType
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. |