Alter User to grant privileges to a table results in incorrect script and "Undefined name" error (4312572)

In the Object explorer:

Right-click on a User | Alter User Select Table | click button to 'Add a table'

On selection of a table where the schema is double-quoted: "schema".tablename e.g. "dan".test Toad will produce the following script, adding multiple double-quotes.

SET CURRENT SQLID=USER;
GRANT SELECT ON """""""dan""""""".TEST TO ABC;
COMMIT;

If the script is executed, then the following error results:

ERROR [42704] [IBM][DB2] SQL0204N """"dan""".TEST" is an undefined name.

Defect specific to schema name that has double-quotes

WORKAROUND

1. Click the 'Open script in Editor' button
2. Remove unnecessary double-quotes
3. Execute script in the Editor

STATUS

Waiting for fix in a future release of Toad for DB2