SQL Server - How do I find out the execute permission of a particular SPROC?

SQL Server - How do I find out the execute permission of a particular SPROC?
LVL 1
CipherISAsked:
Who is Participating?
 
Paul JacksonConnect With a Mentor Software EngineerCommented:
Right-click the stored procedure and select properties, click the permissions page and the permissions for the stored procedure can be seen in the right hand pane.
0
 
CipherISAuthor Commented:
I did that - i'm trying to give same permissions to another SPROC.  I added the users from SPROC A to SPROC B and gave the permission to execute but its not working - receive EXECUTE Permission error on SPROC B.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.