Apply For A Course Click Here
Book Consultation Click Here

Exec permission on SP

DWQA QuestionsCategory: QuestionsExec permission on SP
Brian asked 2 weeks ago

How can I grant exec permission to a user on all store procedures in a database?

1 Answers
pfote Staff answered 2 weeks ago

Create a role then add this role to users, and then you can grant execute to all the routines in one shot to this role.

CREATE ROLE <abc>
GRANT EXECUTE TO <abc>

Your Answer