Public use of stored procedures in master database 1

[roblasch]

I use the stored procedure sp_makewebtask from the master database to rebuild some web pages when changes are made. This action is called from another stored procedure and accessed through an interface on a web page. I get an error message that says the user must be a member of the sysadmin role. Lo and behold, when I add give the login admin priveliges everything is fine. So my question is this: How can I limit the login to only execute the single stored procedure in the master database (in addition to the other priveliges in it's own database that it has), without granting any other priveliges. I don't want people using the web interface to have administator priveliges for obvious reasons (tell me if that is flawed thinking). Thanks

 

[JBaileys]

You can select the permissions by creating a new role. Anyone that you want to limit their permissions should be part of the role. Select permissions and scroll through the objects that you want to give them permission.