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
-
- Because the dashboard uses the ASNCLP command-line program to perform replication setup tasks, the user ID that runs the dashboard requires the same authorizations that the ASNCLP program requires. See Authorization requirements for the Replication Center and ASNCLP program for details.
- You can enable the dashboard to list IBM® MQ queues that are needed when creating replication queue maps on z/OS. See Optional: Enabling the replication administration tools to work with IBM MQ on z/OS for details.
- 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.