Authorities and privileges for migrating the EXPLAIN tables for Visual Explain

You must have the authorities and privileges that are required to migrate the EXPLAIN tables on the subsystems.

If you have the SYSADM authority, you can migrate the EXPLAIN tables on the subsystem. Otherwise, see the following table for detailed authorities and privileges that are required for each individual tasks of migrating the EXPLAIN tables.

Task Authorities or privileges required
Alter EXPLAIN tables One or more of the following privileges or authorities:
  • The ALTER privilege on the table
  • Ownership of the table
  • DBADM authority for the database
  • SYSADM or SYSCTRL authority
Create EXPLAIN tables If you want to create the EXPLAIN tables in a new database, one or more of the following privileges or authorities for creating the database:
  • CREATEDBA privilege
  • CREATEDBC privilege
  • SYSADM or SYSCTRL authority
For creating the table space, one or more of the following privileges or authorities:
  • CREATETS privilege for the database
  • DBADM, DBCTRL, or DBMAINT authority for the database
  • SYSADM or SYSCTRL authority
For creating the tables, one or more of the following privileges or authorities:
  • CREATETAB privilege for the database
  • DBADM, DBCTRL, or DBMAINT authority for the database
  • SYSADM or SYSCTRL authority
Bind packages One of the following authorities and privileges:
  • SYSADM or DBADM authority
  • BINDADD privilege if required packages do not exist, and CREATEIN privilege on the schema
  • ALTERIN privilege on the schema if the required packages exist
  • BIND privilege on the required packages if they exist

Feedback