Topic Last Modified: 2012-09-12

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.