Published on InterSystems Developer Community (https://community.intersystems.com)

Home > ODBC viewing the table information

Question
Marco den Hartog · Mar 6, 2019

ODBC viewing the table information

Hi community,

I have a rights problem when giving a user permission to perform some select queries on particular tables. So I have created a user with the following rights.

So this all works well. No problem so far. But the customer is using a program where you can easily build visually the query by selecting the table, choose the right colums etc. So the problem we have is when I give the user the Role %All the tables are shown.

And the user is allowed to query all tables. But we only need to see the granted tables granted, so role %All is not valid but is the only Role, Permission I have tried so far that shows the table information correctly.

So what do I need to do for only showing table information (schema information) for the granted tables. 

#ODBC #Caché #HealthShare

Source URL:https://community.intersystems.com/post/odbc-viewing-table-information