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

Discussion (6)1
Log in or sign up to continue

I'm a bit confused here - granting the user SELECT privileges on those tables didn't allow your customer's ODBC client to work?  It sounds like %ALL is working as designed (if you have %ALL you own the system and can therefore see everything).  What does the client tool look like when you grant just SELECT access to certain tables or schemas?  Can you try a different ODBC client to see how that behaves (I like WinSQL)?