Access catalog tables and views

IBM® Security Identity Manager creates and uses these database tables and views to store information related to Access Catalog.

T_AccessCatalog table
The T_AccessCatalog⁴ table stores information about the access, including name, description, category, badge, and search terms. The access information is displayed in the Request Access user interface in the Identity Service Center.
T_AccessCatalogTags table
The T_AccessCatalogTags⁴ table stores the access search terms. Each access can have zero or many search terms defined.
T_BADGES table
The T_BADGES⁴ table stores the access badge information.
T_Owner table
The T_Owner⁴ table stores the access owner information.
T_GROUP table
The T_GROUP⁴ table stores the information for group entities.
T_Role table
The T_Role⁴ table stores the information for the role entities.
T_ProvisioningPolicy table
The T_ProvisioningPolicy⁴ table stores the information for provisioning policies. This information is replicated from LDAP to the database to optimize performance when searching for authorized access.
T_PolicyMembership table
The T_PolicyMembership⁴ table stores the information for the memberships of a provisioning policy.
T_ServiceEntitlement table
The T_ServiceEntitlement⁴ table stores the information for the service entitlement of a provisioning policy.
T_AttributeEntitlement table
The T_AttributeEntitlement⁴ table stores the information for the entitled attribute values of a service entitlement in a provisioning policy.
T_ServiceTags table
The T_ServiceTags⁴ table stores the information for service tags for a service entitlement in a provisioning policy.
TMP_HostSEByPerson table
The TMP_HostSEByPerson⁴ table stores the information for service targets that are applicable to a specific user according to the host selection policy when a service entitlement target type is host selection policy. Information in this table is dynamically generated during service or group authorization for a specific user, and it is associated with a unique transaction ID that corresponds to the authorization evaluation process. The data is automatically removed by the system upon completion of the authorization evaluation process.
TMP_JSAEByPerson table
The TMP_JSAEByPerson⁴ table stores the information for the evaluated JavaScript attribute values for a specific user according to the attribute entitlements with the JavaScript value type in a provisioning policy. Information in this table is dynamically generated during service or group authorization for a specific user, and it is associated with a unique transaction ID that corresponds to the authorization evaluation process. The data is automatically removed by the system upon completion of the authorization evaluation process.
T_Global_Settings table
The T_Global_Settings⁴ table stores the global configuration properties for IBM Security Identity Manager that are required for service and group authorization evaluation.
T_GROUP_PROFILE table
The T_GROUP_PROFILE⁴ table stores the group profile information.
T_Joindirective table
The T_Joindirective⁴ table stores the attribute join directive definitions.
V_GroupCatalog view
The V_GroupCatalog⁴ view provides information for groups in the access catalog.
V_RoleCatalog view
The V_RoleCatalog⁴ view provides information for roles in the access catalog.
V_ServiceCatalog view
The V_ServiceCatalog⁴ view provides information for services in the access catalog.
V_DYNAMIC_ENTITLEMENT view
The V_DYNAMIC_ENTITLEMENT⁴ view provides information for entitlements in the provisioning policy that need to be dynamically evaluated.
V_ServiceEntitlementByRole view
The V_ServiceEntitlementByRole⁴ view provides information about service entitlements by role.
V_GROUP_PROFILE view
The V_GROUP_PROFILE⁴ view provides metadata for groups.
V_GC_INTERSECT view
The V_GC_INTERSECT⁴ view provides information for groups in the access catalog that use intersection join in the provisioning policy.
V_GC_CUSTOM view
The V_GC_CUSTOM⁴ view provides information for groups in the access catalog that use custom join in the provisioning policy.

Parent topic: Database tables reference