Return
-
Title
Cancel query causes error, "ERROR [42501] [IBM][DB2] SQL0551N "Schema_Name_1" does not have the r -
Description
I'm logged into a DB2 database as a limited user where I don't have access to all the tables. I'm using the Query Builder tool to generate a query from table X where I have access and it would be currently highlighted in the Object Explorer.
Whenever I cancel the running query, the Object Explorer will loose focus on table X and jump to the top of the list of tabes in the Object Explorer to another table where I don't have access to. Thus this action causes the error:ERROR [42501] [IBM][DB2] SQL0551N "Schema_Name_1" does not have the required authorization or privilege to perform operatin "SELECT" on object "schema_2.table_name". SQLSTATE=42501 -
Resolution
WORKAROUND:
None.
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts.