Revoke syntax generated by Toad, results in the following error
"Lookup Error - DB2 Database Error: ERROR [42601] [IBM][DB2/NT64] SQL0104N An unexpected token ""SYSTOOLS"" was found following "TROL, SELECT ON VIEW".
Expected tokens may include: "<space>"." for a Views, Nicknames and Functions
WORKAROUND:
See link http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0000990.html&resultof=%22revoke%22%20%22revok%22%20%22view%22
for information on correct statements.
STATUS:
Enhancement request ST93422 has been submitted to Development for consideration in a future release of Toad for DB2.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center