Kbase P8835: How to allow general users the ability to review their query plans for SQL92.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to allow general users the ability to review their query plans for SQL92.
FACT(s) (Environment):
Progress 9.x
FIX:
It may be beneficial for some users to review the efficiency of the SQL statements. In SQL92, Progress can generate a Query Plan after running SQL statement.
For a user other than DBA to review the query plan they need to be granted SELECT privileges on the _Sql_Qplan table.
Example:
grant select on pub."_Sql_Qplan" to user1;
commit;