IBM Db2 11.1 Certification Guide

The Explain administrator authority (EXPLAIN)

Users with EXPLAIN authority can perform the following tasks:

• Generate access plan information for SQL statements
• Prepare SQL statements
• Perform a DESCRIBE on an output of a SELECT statement or of an XQuery statement

You can assign EXPLAIN authority on a database called SAMPLE to the user john by executing the following statement:

CONNECT TO sample; 
GRANT EXPLAIN ON DATABASE TO USER john;

If you want to revoke EXPLAIN authority on a database called SAMPLE from the user john, execute the following statement:

CONNECT TO sample; 
REVOKE EXPLAIN ON DATABASE FROM USER john;