For the command-line challenged, you can go to the database properties by right clicking the database name on the Object Explorer, select Properties to open the Database Properties dialog. On the left, select the Permissions page, under the Explicit tab, scroll down until you see the Execute permission, and check the Grant column like so.
This gives the user the ability to run any stored procedure in that database, including any stored procedure created afterwards.
No comments:
Post a Comment