0
350
Question Juergen Caris · Dec 11, 2020

ODBC user cannot see the catalog

#InterSystems IRIS #InterSystems IRIS for Health #ODBC #SQL

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
Discussion (2)2
Log in or sign up to continue

Comments

Rich Taylor · Dec 17, 2020

Have you granted these users the %SQL role?

0
Eduard Lebedyuk · Dec 17, 2020

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

0