Permissions by user group to change data.
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.
Column Name | Description | Datatype | Length | Allow Nulls |
|
---|---|---|---|---|---|
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 |
Index | Primary | Unique |
---|---|---|
TB_PRIMARYKEY |
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |