I'm attempting to create a report, after selecting table, columns, I receive the following error: ODBC interface (function 'SQLExecute') [CA][Ingres ODBC Driver][Ingres]SELECT on table XXX: no GRANT or GRANT compatible permit exists.

Document ID : KB000027702
Last Modified Date : 14/02/2018
Show Technical Document Details

The user accessing the Ingres DB through ODBC driver does not have rights to view table. You will need to Grant the user access to the table from Ingres DB utility or replace the user/password assigned in the ODBC driver configuration to another user/password that has access to the table.