SecurityGroupPrivs Table

Applies to QAComplete 14.3, last modified on February 19, 2024

Description

Stores privileges of security groups.

Columns

The table contains the following columns:

SecurityGroupPrivId  :  int, primary key, allows null: no

The ID of the security group privilege.

SecurityGroupId  :  int, allows null: no

The ID of the security group.

CanAdd  :  char (max 1 char), allows null: no

Indicates whether the users of the security group can add new items to the security entity.

CanDelete  :  char (max 1 char), allows null: no

Indicates whether the users of the security group can delete items from the security entity.

CanRead  :  char (max 1 char), allows null: no

Indicates whether the users of the security group can read items of the security entities.

CanUpdate  :  char (max 1 char), allows null: no

Indicates whether the users of the security group can update items of the security entity.

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time the privilege was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no, default: Current date and time

The date the time the privilege was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

EntityCode  :  varchar (max 100 chars), allows null: no

The code of the security entity (the system aspect being controlled).

You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

SecurityGroupPrivs View
Setup

Highlight search results