Why do I see EVERY table in the DB, insted of just ones I have rights?

[A122019]

In Excel ODBC, I see every table in the database, not just the ones to which I have rights.

I am using ODBC(via InfoAccess) to get data from our DMSII databases. (Unisys) This problem began when we upgraded from InfoAccess 4.2 to 4.2.According to Unisys this "new feature" is ODBC compliant and release 4.2 was not compliant. ODBC allows you to select the table, build the query, and only when you submit the query do you get the warning that you do not have permissions to the table.

I just can't believe this is ODBC compliant. I am curious if others have this same problem. Maybe the problem is the result of how our installation was done. Maybe there's something I can turn off or turn on and fix this.

So, is this the way ODBC works or is this specific to Unisys and InfoAccess?

I appreciate your help!

Any help out there?

 

[PHettinger]

I'm inclined to think this is how ODBC works. I'm working on a project using IWay software to connect to mainframe data, especially DB2 and have the same thing happen. I can read the metadata for every single table in the database but still can read only those I have SELECT authority for. That's probably because I have SELECT authority over the system tables.

Your access to this tables may have changed too when you upgraded. Your DBA could tell you.

P.H.