Skip to main content

Purpose

Contains permissions for users or user groups. Allows connections with certain role types. Access blocks are not used in this version. Diagram of relationships between access control tables

List of columns

Key

Name

Type

Required

Description

PK

Id

int

yes

Entry identifier.

 

BatchTypeId

int

no

Batch type identifier. Corresponds to the entry identifier in the BatchType table.

  • 0” means permissions are granted for “Default ” type batches.
  • Null” means that permissions are granted for all types of packets.

IsAllowed

bit

yes

Indicates that access is allowed. Currently access blocks are not used, instead permissions are issued to all users that require access.

PrincipalId

int

yes

User identifier. Corresponds to the entry identifier in the Principal table.

ProjectId

int

no

Batch type identifier. Corresponds to the entry identifier in the Project table. The value “null” gives access permissions to all projects.

RoleType

int

yes

Role types for which a user or user group has permissions. Possible values are listed in User Role Type.