Question
Juergen Caris · Dec 11, 2020

ODBC user cannot see the catalog

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

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
0
0 187
Discussion (2)2
Log in or sign up to continue
Rich Taylor · Dec 17, 2020

Have you granted these users the %SQL role?

0 0
Eduard Lebedyuk · Dec 17, 2020

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

0 0