tblScopePrincipal
tblScopePrincipal contains scopes assigned to nodes.
Columns
| Column | Type | Description |
|---|---|---|
| scopeNodeID |
int, not null |
Node ID that the scope applies to. |
| scopePrinID |
int, not null |
Principal ID. |
| scopeIsDenied |
bit, not null |
True if type of scope is Deny; False if Allow. |
| scopeUpdatedBy |
int, not null |
ID of the principal that last updated this entry. |
Keys
| Column | Description |
|---|---|
| <scopeNodeID, scopePrinID> |
Primary key. |
| scopeNodeID |
Foreign key with lookup in tblNode.nodeID table. |
| scopePrinID |
Foreign key with lookup in tblPrincipal.prinID table. |