Required database privileges for the dashboard

The InfoSphere® Data Replication Dashboard issues SQL statements on the databases that are involved in replication to fetch monitoring data and for other related functions. Each user ID that you provide to the dashboard for connecting to various databases must have the following privileges, depending on the dashboard functions that you use.

Create monitoring groups and fetching monitoring data
SELECT on all Q replication control tables (names that start with IBMQREP_), and the following other privileges:
Db2® for z/OS®
  • SELECT on SYSIBM.SYSTABLES, SYSIBM.SYSDUMMY1, SYSIBM.SYSINDEXES, SYSIBM.SYSKEYS
  • If the ARCH_LEVEL value in the control tables is lower than 0907, and if monitoring queue depth as a percentage is required, EXECUTE on the ASN.GET_QUEUE_DEPTH stored procedure
Db2 for Linux®, UNIX, Windows
  • SELECT on SYSCAT.TABLES, SYSIBM.SYSDUMMY1, SYSCAT.INDEXES
  • If the ARCH_LEVEL value in the control tables is lower than 0907, and if monitoring queue depth as a percentage is required, SELECT on SYSIBM.SYSPROCEDURES and execute permission on the ASN.GET_QUEUE_DEPTH stored procedure
Oracle
  • SELECT on SYS.ALL_TABLES, DUAL, SYS.ALL_INDEXES, SYS.ALL_IND_COLUMNS
Perform various functions in the dashboard
Setting up Q Replication
Changing Q Capture, Q Apply, send queue, and receive queue properties
INSERT and UPDATE on the IBMQREP_CAPPARMS, IBMQREP_APPLYPARMS, IBMQREP_SENDQUEUES, and IBMQREP_RECVQUEUES tables, respectively
Start-stop-reinitialize-load done on table-level Q subscriptions, start-stop-reinitialize on schema-level subscriptions, and start-stop on send queues
INSERT on the IBMQREP_SIGNAL table
Add column on Q subscriptions
Db2
SELECT on SYSIBM.SYSCOLUMNS and SYSIBM.SYSDATATYPES, and INSERT on IBMQREP_SIGNAL
Oracle
SELECT on SYS.ALL_CONSTRAINTS CONS, SYS.ALL_CONS_COLUMNS COLS, SYS.ALL_TAB_COLUMNS, and INSERT and UPDATE on IBMQREP_SIGNAL
Showing the number of database partitions on the Subscriptions tab
Db2 for z/OS
SELECT on SYSIBM.SYSTABLEPART
Db2 for Linux, UNIX, Windows
SELECT on SYSCAT.DATAPARTITIONS
Oracle
SELECT on ALL_TAB_STATISTICS
Viewing sample data in the Subscriptions tab
  • SELECT on the source and target tables for the Q subscription
  • INSERT, UPDATE, and DELETE on the source and target tables to allow insert, update, and delete operations
Showing table information in the Subscription tab
Db2 for z/OS
SELECT on SYSIBM.SYSTABLES
Db2 for Linux, UNIX, Windows
SELECT on SYSCAT.TABLES
Oracle
SELECT on SYS.ALL_TAB_COLUMNS, SYS.ALL_TABLES, SYS.ALL_OBJECTS
Support for temporal tables in the Subscription tab
Db2 for z/OS
SELECT on SYSIBM.SYSTABLES
Db2 for Linux, UNIX, Windows
SELECT on SYSCAT.TABLES, SYSCAT.PERIODS
Oracle
This feature is not supported for Oracle.