IBM Support

Security Tables For CCMDB 7.1.1 / 7.5 / 7.6

Question & Answer


Question

List of the security tables for CCMDB 7x ?

Answer

The following is a list of tables updated by the various security applications and the security related application that updates the table.

Table
App that writes to the table


    APPLICATIONAUTH
    Security Groups (Applications Tab)
    COLLECTIONAUTH
    Security Groups (data Restrictions tab, Collection Authorization sub-tab)
    CONDITION
    Security Groups (Applications Tab or Data Restrictions Tab – need to ‘GOTO’ Conditional Application Manager)
    CTRLCONDITION
    Application Designer – condition information used in conditional UI configurations
    CTRLCONDPROP
    Application Designer – property values used in conditional UI configurations
    CTRLGROUP
    Application Designer – security group information used in conditional UI configurations
    EMAIL
    Users
    EXCLUDEPASSWORD
    Users, Change Password – list of excluded passwords. Not applicable when application server security (LDAP) is used for authentication.
    GLAUTH
    Security Groups (GL Components tab)
    GROUPUSER
    Security Groups (Users tab), Users (Security Groups tab). Not applicable when application server security (LDAP) is used for authentication.
    GRPREASSIGNAUTH
    Users (Authorize Group Reassignment Action), Security Groups (Authorize Group Reassignment Action). Not applicable when application server security (LDAP) is used for authentication.
    LABORAUTH
    Security Groups (Labor tab)
    LIMITTOLERANCE
    Security Groups (Limits & Tolerances tab)
    LOCAUTH
    Security Groups (Storeroom tab)
    LOGINTRACKING
    Login, E-Sig
    MAXGROUP
    Security Groups (Main Tab; Sites, Labor, GL Components and Storerooms tabs if group is authorized for all Sites, any Labor ‘quick pick’ options, all GL Components or all Storerooms; Override Password Duration Action)

    MAXSESSION
    Login, Users (Manage Sessions Action)
    MAXUSER
    Users.
    MAXUSERSTATUS
    Users (Change Status action)
    MAXVARS
    Security Groups or Users – Security Controls Action
    PASSWORDHISTORY
    Users (New User or Change Password Action), Change Password. Not applicable when application server security (LDAP) is used for authentication.
    PERSON
    Users
    PHONE
    Users
    SECURITYRESTRICT
    Security Groups (Data Restrictions tab)
    SIGOPTION
    Application Designer – addition of signature options to be utilized in conditional UI.
    SITEAUTH
    Security Groups (Sites Tab)
    USERPURGL
    Users

[{"Product":{"code":"SSKTXT","label":"Tivoli Change and Configuration Management Database"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1.1;7.5","Edition":"Standard","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21293000

Page Feedback