title: Grant role to exec stored procedures
body: <p>I have a proxy user that I'm trying to add to a role that can execute all stored procedures. Using other StackOverflow posts, I have been able to put together this script</p>
  
  <pre><code>USE abc
  
  Create ROLE db_exec
  go
  
  GRANT EXECUTE TO db_exec
  go
  
  EXEC sp_addrolemember 'db_exec', 'abc_user'
  go
  </code></pre>
  
  <p>When I try to run my stored procedures though, I'm still getting this error, per my error handling.  </p>
  
  <blockquote>
    <p>The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.</p>
  </blockquote>
  
  <p>What can I do to let <code>abc_user</code> execute <code>sp_OACreate</code>?</p>