title: How to limit user view of system tables / views
body: <p>I am using SQL Server 2008R2 and one of the things I am trying to do is allow users read-only access to some of the tables in one of the DBs via MS Access ODBC so that they cna build their own reports, etc (Their request).  The problem is that they can see all of the system views /tables (information_schema and merge replication stuff).  Is there anyway that I can revoke these so that all they can see are the tables /views I designate as available for selection?</p>
  
  <p>Not sure what I can do to limit what they see as "available".</p>
  
  <p>Thanks,</p>
  
  <p>S</p>