This step should be run for each DB2 subsystem that requires an interface to Control‑M/Analyzer. For each user that needs to use the interface, add the following authorization:
GRANT EXECUTE ON PLAN CTBDB2 TO user‑name ;
For each of these users, grant SELECT capabilities for each table they need to access. This authorization is required because the interface uses Dynamic SQL. Generally, the following authorization should be added for each user who was not previously authorized:
GRANT SELECT ON TABLE table‑name TO user‑name ;
For additional details, see the IBM Database 2 SQL Reference Manual and Administration Guide.
Parent Topic |