SAP/DB2 connections via ODBC - How to limit the number of visible tables
When accessing DB2 via ODBC for, say, some Z-table information I find that some 3rd party apps like UPS Worldship cannot handle the number of tables returned. This was also true with SQLServer BTW.
Is it possible to limit the number of tables that are returned by DB2 via the ODBC driver for Windows?
I log in with a user that only has rights on 8 tables. I was hoping that applications like MSAccess and UPS Worldship would only see those 8 tables when using that specific DB2 login. That would be "problem sovled" but it seems not to be the case. Even MSAccess lists ALL of the tables but only lets you use those you have access to. Certinaly there must be a way to hide the table names from a user that has no access to them.
BTW: This gets to be a huge problem in ERP6 because the number of tables jumps dramatically from 4.6b where I am today.
Thank you for any tips.