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 | 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. |
| FTMUser | 1 | 2 | View access to alerts for App 2. |
| FTMUser | 2 | 2 | View access to mappers for App 2. |
| FTMUser | 3 | 2 | View access to transaction for App 2. |
| FTMUser | 4 | 2 | View access to configuration values for App 2. |
| FTMUser | 5 | 2 | View access to formats for App 2. |
| FTMUser | 6 | 2 | View resolution actions for App 2. |
| FTMAdmin | 7 | 2 | Execute access to resolution action cancel 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. |
Up to now, no resource permissions were assigned for the application App 3. To grant permissions to FTMAdmin for App 3, you must add the following entries to the database:
| GROUP_NAME | RESPERM_ID | APP_ID | Remarks |
|---|---|---|---|
| FTMAdmin | 1 | 3 | View access to alerts for App 3. |
| FTMAdmin | 2 | 3 | View access to mappers for App 3. |
| FTMAdmin | 3 | 3 | View access to transactions for App 3. |
| FTMAdmin | 4 | 3 | View access to configuration values for App 3. |
| FTMAdmin | 5 | 3 | View access to formats for App 3. |
| FTMAdmin | 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. |