September 5, 2002 at 5:59 am
sp_makewebtask can only be executed by the
sysadmin role by default. I want to give some users the right to execute sp_makewebtask but I dont want to add them to sysadmin. I created the new role and gave it execute rights to sp_makewebtask. When the user trys to execute the proc he still gets the error (only sysadmin role can execute this procedure)
What am I doing wrong ?
September 5, 2002 at 6:33 am
The check is hard coded into the app. You "could" modify the proc and remove that check. Even then, depending on the options selected they would have to have permission to add triggers to a table. Usually having them do this type of thing using ASP is a better option. Other than that you could have them load their params into a table, then run a job as sa that would pick up the params and run the webtask proc.
Andy
September 5, 2002 at 8:53 am
Thanks for the info andy. What I did was create new proc in my db called ups_makewebtask and just removed the sysadmin edit. I also added an edit to prevent the user from trying to schedule tasks (@whentype <> 1 ).
Since the users dont need to schedule tasks
I think this should work for them.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply