title: GRANT VIEW on 1 database
body: <p>Is there any work around to grant view on a particular database after executing the below code?, I am using MS SQL 2008 RC2.</p>
  
  <pre><code>REVOKE VIEW ANY DATABASE FROM &lt;login&gt;;
  </code></pre>
  
  <p>Thanks</p>