title: Finding stored procedures having execute permission
body: <p>I am using SQL Server 2008 R2. I need to list out all the stored procedures that a database user (MYUSER)  has execute permission. </p>
  
  <p>Also, I need to list out which are the stored procedures that the user does NOT have EXECUTE permission - but can read the script of the stored procedure</p>
  
  <p>Is there any SQL statement or helper function for these purpose?</p>
  
  <p>REFERENCE:</p>
  
  <ol>
  <li><a href="https://stackoverflow.com/questions/5109581/granting-execute-permission-on-all-stored-procedures-in-a-certain-database">Granting execute permission on all stored procedures in a certain database</a></li>
  </ol>