title: SQL Server: Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself
body: <p>I am configuring a new SQL Server 2008 R2 and am getting the following error when I was trying to grant exec permission on stored procedures to users using the statement like </p>
  
  <pre><code>grant exec on [schemaName].[StoredProcedureName] TO userName
  </code></pre>
  
  <p>The error I am getting:</p>
  
  <blockquote>
    <p>Cannot grant, deny, or revoke permissions to sa, dbo, entity owner,
    information_schema, sys, or yourself.</p>
  </blockquote>
  
  <p>I am able to grant other permissions such as select permission to synonyms. I am also able to creating logins and creating users based on the logins and grant the users datawriter and datareader roles.</p>
  
  <p>I have the public, serveradmin and sysadmin server roles. I have db_owner role in the database where I was trying to grant the permissions.</p>
  
  <p>I have never had this issue before.</p>
  
  <p>What am I missing?</p>