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.

Products

• Cleverpath Reporter

Issue/Introduction

The user accessing the Ingres DB through ODBC driver does not have rights to view table. 

Environment

Release:
Component: CVPRPT

Resolution

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.