Re: Authorization needed to use EXPLAIN

Michael McMorrow

Re: Authorization needed to use EXPLAIN
(in response to Gilgian Schranz)
Gilgian,
I raised the same issue a couple on months ago on this
list....Unfortunately that's just the way it is....You need the same DB2
authority to Explain a query as to Run a query....Bizarre....Maybe a
friendly IBM developer will take it on board sometime???
Michael Mc Morrow.
DBA Manager, AIB Bank, Dublin.

----------
> From: Gilgian Schranz <[login to unmask email]>
> To: [login to unmask email]
> Subject: Authorization needed to use EXPLAIN
> Date: 08 October 1999 18:46
>
> Manual "DB2 for OS/390 Version 5 SQL Reference" says that the
authorization
> rules for the EXPLAIN statement are those defined for the SQL statement
> specified in the EXPLAIN statement. For example, to EXPLAIN a DELETE
> statement, the authorization needed to execute the DELETE statement is
> necessary to explain it.
>
> In our production environment we only have SELECT authority. We have no
> chance to get, and we don't really need, more rights. But we would like
to
> use the EXPLAIN statement without the need to modify the SQL statements
> extracted from the programs.
>
> Does somebody know the reason for the restrictive implementation of the
> EXPLAIN statement? Is there any way to change the authorization needs at
the
> installation?
**********************************************************************
This document is strictly confidential and is intended for use by
the addressee unless otherwise indicated.

Allied Irish Banks
**********************************************************************

Gilgian Schranz

Authorization needed to use EXPLAIN
Manual "DB2 for OS/390 Version 5 SQL Reference" says that the authorization
rules for the EXPLAIN statement are those defined for the SQL statement
specified in the EXPLAIN statement. For example, to EXPLAIN a DELETE
statement, the authorization needed to execute the DELETE statement is
necessary to explain it.

In our production environment we only have SELECT authority. We have no
chance to get, and we don't really need, more rights. But we would like to
use the EXPLAIN statement without the need to modify the SQL statements
extracted from the programs.

Does somebody know the reason for the restrictive implementation of the
EXPLAIN statement? Is there any way to change the authorization needs at the
installation?