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.
Regards,
Juergen
Product version:
IRIS 2020.2
Have you granted these users the %SQL role?
SELECT on
INFORMATION_SCHEMA.TABLES
and maybe some other tables fromINFORMATION_SCHEMA
schema.