Database tables for RM data

Table 1. Database tables for RM data
Table name and description Table space Buffer pool
DNF_RMRL — RM Relationships Table DNFRMRL DNIvBP4K
DNF_RMAD — RMA Authorisation Data Table DNFRMDP DNIvBP4K
DNF_RMAD_CTRLA — RMA Authorisation Data Table, control data
DNF_RMAD_CTRLB — RMA Authorisation Data Table, control data
DNF_RMAP — RMA Authorization Permissions Table
DNF_RMAP_CTRLA — RMA Authorisation Permissions Table, control data
DNF_RMAP_CTRLB — RMA Authorisation Permissions Table, control data
DNF_RMAL — RMA Authorisation Large Objects Table DNFRMAL DNIvBP16K
DNF_RMAH — RMA Authorization History Table DNFRMAH DNIvBP16K
DNF_RMAH_CTRLA — RMA Authorization History Table, control data
DNF_RMAH_CTRLB — RMA Authorization History Table, control data
DNF_RMYS — RMA Synchronization Request Status Table DNFRMY DNIvBP4K
Table 2. Permissions granted to the database role DNI_SERVER
Object type Name INSERT SELECT UPDATE DELETE
table DNF_RMRL YES YES YES YES
table DNF_RMAD YES YES YES YES
table DNF_RMAD_CTRLA YES YES YES YES
table DNF_RMAD_CTRLB YES YES YES YES
table DNF_RMAP YES YES YES YES
table DNF_RMAP_CTRLA YES YES YES YES
table DNF_RMAP_CTRLB YES YES YES YES
table DNF_RMAL YES YES YES YES
table DNF_RMAH YES YES YES YES
table DNF_RMAH_CTRLA YES YES YES YES
table DNF_RMAH_CTRLB YES YES YES YES
table DNF_RMYS YES YES YES YES
Table 3. Permissions granted to the database role DNI_APP_SERVER
Object type Name INSERT SELECT UPDATE DELETE
table DNF_RMRL YES YES YES YES
table DNF_RMAD YES YES YES YES
table DNF_RMAP YES YES YES YES
table DNF_RMAL YES YES YES YES
table DNF_RMAH YES YES YES YES
table DNF_RMAD_CTRLA YES YES YES YES
table DNF_RMAD_CTRLB YES YES YES YES
table DNF_RMAP_CTRLA YES YES YES YES
table DNF_RMAP_CTRLB YES YES YES YES
table DNF_RMAH_CTRLA YES YES YES YES
table DNF_RMAH_CTRLB YES YES YES YES
table DNF_RMQS_CTRLA YES YES YES YES
table DNF_RMQS_CTRLB YES YES YES YES
table DNF_RMQH_CTRLA YES YES YES YES
table DNF_RMQH_CTRLB YES YES YES YES
Table 4. Permissions granted to the database roles DNI_DI_ADMIN, DNI_DI_OPERATION, DNI_DI_VALIDATION, and DNI_DI_DISPOSE
Name DNI_DI_ADMIN DNI_DI_OPERATION DNI_DI_VALIDATION DNI_DI_DISPOSE
INS UPD SEL DEL INS UPD SEL DEL INS UPD SEL DEL INS UPD SEL DEL
DNF_RMRL     ✓       ✓       ✓       ✓ ✓
DNF_RMAD ✓   ✓ ✓ ✓ ✓ ✓ ✓     ✓       ✓ ✓
DNF_RMAP ✓   ✓ ✓ ✓ ✓ ✓ ✓     ✓       ✓ ✓
DNF_RMAL     ✓       ✓       ✓       ✓ ✓
DNF_RMAH ✓   ✓ ✓ ✓ ✓ ✓ ✓     ✓       ✓ ✓
DNF_RMAD_CTRLB     ✓       ✓       ✓       ✓ ✓
DNF_RMAP_CTRLA ✓   ✓ ✓ ✓ ✓ ✓ ✓     ✓       ✓ ✓
DNF_RMAP_CTRLB ✓   ✓ ✓ ✓ ✓ ✓ ✓     ✓       ✓ ✓
DNF_RMAH_CTRLA     ✓       ✓       ✓       ✓ ✓
DNF_RMAH_CTRLB ✓   ✓ ✓ ✓ ✓ ✓ ✓     ✓       ✓ ✓