title: SqlTableDependency Permission Issues
body: <p>I am trying to use the SqlTableDependency class  in my C# .Net application and I am unable to grant myself the required database permissions needed. Specifically, I need permissions: </p>
  
  <ul>
  <li>ALTER</li>
  <li>CONTROL</li>
  <li>CREATE CONTRACT</li>
  <li>CREATE MESSAGE TYPE</li>
  <li>CREATE PROCEDURE</li>
  <li>CREATE QUEUE</li>
  <li>CREATE SERVICE</li>
  <li>EXECUTE</li>
  <li>SELECT</li>
  <li>SUBSCRIBE QUERY NOTIFICATIONS</li>
  <li>VIEW DATABASE STATE</li>
  <li>VIEW DEFINITION</li>
  <li>CONNECT</li>
  </ul>
  
  <p>The error message states:</p>
  
  <blockquote>
    <p>"An unhandled exception of type
    'TableDependency.SqlClient.Exceptions.UserWithNoPermissionException'
    occurred in TableDependency.SqlClient.dll. Additional information:
    User with no CREATE MESSAGE TYPE permission"</p>
  </blockquote>
  
  <p>I have tried granting myself the permission using this query:</p>
  
  <pre><code>GRANT CREATE MESSAGE TYPE TO dbo
  </code></pre>
  
  <p>but I get this error:</p>
  
  <blockquote>
    <p>"Cannot grant, deny, or revoke permissions to sa, dbo, entity owner,
    information_schema, sys, or yourself."</p>
  </blockquote>
  
  <p>I have confirmed that dbo is the owner of my database.</p>
  
  <p>I am running Sql Server 2008 R2.</p>
  
  <p>How can I grant myself permissions to my server?</p>