Hello,

as you described, that is exact the same situation for me.

I have users who connect via ODBC and MS Access with an SQL Server Navision DB (SQL Server 2005).

They must connect via sql server authenticated login (because they access from outside our domain).

I have implemented a role and grant special select rights to this role. I have tried to deny on schema sys and INFORMATION_SCHEMA etc. but that doesn't work. The users should see only the user tables, but they also are able to sell all sys-views and information_schema views and i am not able to prevent it.

I have looked in web all around but i found no solution for this topic. Therefore a solution for your problem would be a solution for me too.

Thanks for answer

H.Stenner