title: How to GRANT SELECT permission to all procedures
body: <p>To secure the database interaction, I have created a restricted user who can only execute the stored procedures. He doesn't have any rights to query any table. </p>
  
  <p>This scenario I have implemented very well!. Now the problem is, one of my stored procedure involves dynamic SQL execution, which fails the execution by saying that I don't have the permission to run SELECT query on table X.</p>
  
  <p>To avoid this, I need to provide explicit SELECT permission to such procedures NOT TO USERS.</p>
  
  <p>Please help me!</p>