title: Permission required to view list of tables in Management Studio
body: <p>I searched SO for a pertinent question existing already but couldn't find one.</p>
  
  <p>I am setting up a Read-only database role for a few databases in our server farm. Here is a sample of the permissions for one table:</p>
  
  <pre><code>GRANT SELECT ON [dbo].[Table] TO [ReadOnly]
  GRANT VIEW DEFINITION ON [dbo].[Table] TO [ReadOnly]
  DENY ALTER ON [dbo].[Table] TO [ReadOnly]
  DENY CONTROL ON [dbo].[Table] TO [ReadOnly]
  DENY DELETE ON [dbo].[Table] TO [ReadOnly]
  DENY INSERT ON [dbo].[Table] TO [ReadOnly]
  DENY REFERENCES ON [dbo].[Table] TO [ReadOnly]
  DENY TAKE OWNERSHIP ON [dbo].[Table] TO [ReadOnly]
  DENY UPDATE ON [dbo].[Table] TO [ReadOnly]
  </code></pre>
  
  <p>This works as intended for the SELECT permissions...I'm able to <strong>ONLY</strong> SELECT data, which is exactky what I want.</p>
  
  <p>However, I cannot see the list of tables in the "Tables" tab for the specified database in Management Studio. My goal with this user is to provide some users that are unfamiliar with SQL a login they can use to pull data and start experimenting with SQL. These users are experienced with SAS, a statistical processing language, so they have some experience working with code but not so much <strong>specifically</strong> in SQL.</p>
  
  <p>Which of those permissions will show the list of tables in Management Studio?</p>