Juergen Caris · Dec 11, 2020

ODBC user cannot see the catalog

Hello community,

I need to know what permissions or resources, apart from read for the tables, a user would need to view the catalog via ODBC? The ODBC user can run queries sucessfully but cannot get the catalog from the DB via ODBC. Whereas a a user with %All can fetch the catalog.

Any help would be much appreciated.




Product version:
IRIS 2020.2
2 0 2 100


Have you granted these users the %SQL role?

SELECT on INFORMATION_SCHEMA.TABLES and maybe some other tables from INFORMATION_SCHEMA schema.