GRP_RES_PERM_REL database table
The GRP_RES_PERM_REL database table needs to contain the records that are shown in the following
table.
| GROUP_NAME | RESPERM_ID | APP_ID | Remarks |
|---|---|---|---|
| FTMUser | 1 | 1 | View access to alerts for App 1. |
| FTMUser | 2 | 1 | View access to mappers for App 1 |
| FTMUser | 3 | 1 | View access to transactions for App 1. |
| FTMUser | 4 | 1 | View access to configuration values for App 1. |
| FTMUser | 5 | 1 | View access to formats for App 1 |
| FTMUser | 6 | 1 | View resolution actions for App 1. |
| FTMAdmin | 1 | 1 | View access to alerts for App 1. |
| FTMAdmin | 2 | 1 | View access to mappers for App 1 |
| FTMAdmin | 3 | 1 | View access to transactions for App 1. |
| FTMAdmin | 4 | 1 | View access to configuration values for App 1. |
| FTMAdmin | 5 | 1 | View access to formats for App 1 |
| FTMAdmin | 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. |
Note: The only difference between the GRP_RES_PERM_REL database tables for this single group example and for
the multiple-group example is the additional records for group FTMAdmin relating to RESPERM_ID 1 - 6.