GRP_RES_PERM_REL database table

The GRP_RES_PERM_REL database table needs to contain the records that are shown in the following tables.

Table 1. Content of the GRP_RES_PERM_REL database table for multiple groups with one group per application in multiple applications scenario for App 1
Group name RESPERM_ID APP_ID Remarks
FTMUserApp 1 1 1 View access to alerts for App 1.
FTMUserApp 1 2 1 View access to mappers for App 1
FTMUserApp 1 3 1 View access to transactions for App 1.
FTMUserApp 1 4 1 View access to configuration values for App 1.
FTMUserApp 1 5 1 View access to formats for App 1
FTMUserApp 1 6 1 View resolution actions for App 1.
FTMAdmin 7 1 Execute access to resolution action cancel on invalid batches for App 1.
FTMAdmin 8 1 val_cat access to configuration values category Cat1 for App 1.
FTMAdmin 9 1 Create access to configuration values category Cat1 for App 1.
FTMAdmin 10 1 Delete access to configuration values category Cat1 for App 1.
FTMAdmin 11 1 Edit access to configuration values category Cat1 for App 1.
FTMAdmin 12 1 Create access to formats for App 1.
FTMAdmin 13 1 Delete access to formats for App 1.
FTMAdmin 14 1 Edit access to formats for App 1.
FTMAdmin 15 1 Create access to mappers for App 1.
FTMAdmin 16 1 Delete access to mappers for App 1.
FTMAdmin 17 1 Edit access to mappers for App 1.
Table 2. Content of the GRP_RES_PERM_REL database table for multiple groups with one group per application in multiple applications scenario for App 2
Group name RESPERM_ID APP_ID Remarks
FTMUserApp2 1 2 View access to alerts for App 2.
FTMUserApp2 2 2 View access to mappers for App 2.
FTMUserApp2 3 2 View access to transaction for App 2.
FTMUserApp2 4 2 View access to configuration values for App 2.
FTMUserApp2 5 2 View access to formats for App 2.
FTMUserApp2 6 2 View resolution actions for App 2.
FTMAdmin 7 2 Execute access to resolution action cancel on invalid batches for App 2.
FTMAdmin 8 2 val_cat access to configuration values category Cat1 for App 2.
FTMAdmin 9 2 Create access to configuration values category Cat1 for App 2.
FTMAdmin 10 2 Delete access to configuration values category Cat1 for App 2.
FTMAdmin 11 2 Edit access to configuration values category Cat1 for App 2.
FTMAdmin 12 2 Create access to formats for App 2.
FTMAdmin 13 2 Delete access to formats for App 2.
FTMAdmin 14 2 Edit access to formats for App 2.
FTMAdmin 15 2 Create access to mappers for App 2.
FTMAdmin 16 2 Delete access to mappers for App 2.
FTMAdmin 17 2 Edit access to mappers for App 2.
Table 3. Content of the GRP_RES_PERM_REL database table for multiple groups with one group per application in multiple applications scenario for App 3
Group name RESPERM_ID APP_ID Remarks
FTMUserApp3 1 3 View access to alerts for App 3.
FTMUserApp3 2 3 View access to mappers for App 3.
FTMUserApp3 3 3 View access to transactions for App 3.
FTMUserApp3 4 3 View access to configuration values for App 3.
FTMUserApp3 5 3 View access to formats for App 3.
FTMUserApp3 6 3 View resolution actions for App 3.
FTMAdmin 7 3 Execute access to resolution action cancel on invalid batches for App 3.
FTMAdmin 8 3 val_cat access to configuration values category Cat1 for App 3.
FTMAdmin 9 3 Create access to configuration values category Cat1 for App 3.
FTMAdmin 10 3 Delete access to configuration values category Cat1 for App 3.
FTMAdmin 11 3 Edit access to configuration values category Cat1 for App 3.
FTMAdmin 12 3 Create access to formats for App 3.
FTMAdmin 13 3 Delete access to formats for App 3.
FTMAdmin 14 3 Edit access to formats for App 3.
FTMAdmin 15 3 Create access to mappers for App 3.
FTMAdmin 16 3 Delete access to mappers for App 3.
FTMAdmin 17 3 Edit access to mappers for App 3.