title: how to grant permission to execute but not view stored procedure in sql server
body: <p>I am a developer and want my DBA to give a group of users permissions to execute stored procedures in a schema [Rptg] and view the results but not be able to view the t-sql code in the stored procedure. They will be using Azure Data Studio to connect and execute the stored procedure.  Should we 1st create a role?</p>