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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center