none
How to grant database permission to select the stored procedure alone

    Question

  • Hi,

    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.

    Regards,

    Anbu.

    Thursday, April 25, 2013 8:59 AM

Answers

All replies