- right-click on the stored procedure in the Object Explorer and pick "Properties" from the menu which appears
- pick "Permissions" from the menu at the upper right
- then click the "Search..." button to bring up the "Select Users or Roles" dialog box
- use the "Browse..." button to get what you want and then close out the dialog box with: "OK"
- click the "Grant" checkbox for "Execute" for your line item and then click "OK"
No comments:
Post a Comment