Question
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.

Regards,

Juergen

 

#ODBC #SQL #InterSystems IRIS #InterSystems IRIS for Health #TrakCare
Product version:
IRIS 2020.2
00
2 0 2 100

Replies

Rich Taylor · Dec 17, 2020

Have you granted these users the %SQL role?

00
Eduard Lebedyuk · Dec 17, 2020

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

00