Voltar
-
Título
Alter User to grant privileges to a table results in incorrect script and "Undefined name" error -
Descrição
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.
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.