TABLES Table

Description

Permissions by user group to change data.

Remarks

Fields that control permissions are bit masks that specify the groups whose members can perform the action. If bit X is set, the action is enabled for the group identified with GROUPS.GR_GROUP_ID = X.

For owner-sensible fields, the owner, as defined in TB_OWNER_FIELD_NAME, can perform the action if the owner is a member of a group whose corresponding bit in the owner-sensible field is set. For example, if bit one is set in TB_OWNER_SENSIBLE_DELETE and the owner belongs to group one, the owner can delete the record.

If the entire group has the privilege, the owner-sensible bit is not checked by Quality Center. For example, if bit one is set in TB_GRANT_DELETE and the owner belongs to group one, the owner can delete the record regardless of the value of TB_OWNER_SENSIBLE_DELETE.

Columns

Column Name	Description	Datatype	Length
TB_TABLE_NAME	The name of the table.	VarChar	40
TB_GRANT_DELETE	Permissions to delete records.	VarChar	512
TB_OWNER_SENSIBLE_DELETE	The owner can delete the record if a member of the group.	VarChar	512
TB_GRANT_MODIFY	Permissions to modify records.	VarChar	512
TB_OWNER_SENSIBLE_MODIFY	The owner can modify the record if a member of the group.	VarChar	512
TB_GRANT_ADD	Permissions to add records.	VarChar	512
TB_OWNER_FIELD_NAME	The column in the table that specifies the owner.	VarChar	40
TB_AUDIT_ADD	For future use.	VarChar	1
TB_AUDIT_DELETE	For future use.	VarChar	1
TB_USER_LABEL	Label used when an entity type is presented in the User Interface. For example, the label is used when linking entities.	VarChar	120
TB_IS_CUSTOMIZABLE	A value of Y indicates that the entity can be customized in the user interface.	VarChar	1

Indexes

Index	Primary	Unique
TB_PRIMARYKEY

See Also