ContractSecurityUser Table

ContractSecurityUser stores a list of permissions granted to an operator for a contract with Restricted security.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for ContractSecurityUser table

Database Column

Details

ContractID

Type: integer. Key

The contract with Restricted security. Foreign key to the Contract table.

ActionClassID

Type: integer. Key

The type of permission being granted to the operator. Foreign key to the ActionClass table.

ComplianceOperatorID

Type: integer. Key

The operator that the permission is granted to. Foreign key to the ComplianceOperator table.