If you have the SYSADM authority, you can migrate the EXPLAIN and Query Tuner tables. Otherwise, see the following table for detailed authorities and privileges that are required for each individual tasks.
Task | Authorities or privileges required |
---|---|
Alter EXPLAIN and Query Tuner tables | One or more of the following
privileges or authorities:
|
Create EXPLAIN and Query Tuner tables | If you want to create the tables in a new database,
one or more of the following privileges or authorities for creating
the database:
|
Bind packages | One of the following authorities
and privileges:
|