We have given staging database access with "datareader" permission to one of the team. They are not able to alter the data and also the execution of procedure is not allowed. But we need to give them access to see the schema of the stored procedure. But with this permission, I couldn't achieve it. I want to grant permission to see the schema of all the stored procedures in addition to the "Datareader" permission.
Thanks in advance.
You can give access to view the metadata of the stored procedure which belongs to a particular schema. Check the below link,
Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.
- Proposed as answer by Rick Byham, MicrosoftMicrosoft employee Thursday, April 25, 2013 7:14 PM