Alter EXPLAIN and Query Tuner 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 and Query Tuner 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
|