running sp_MakeWebTask from non admin acct

[bassguy]

Hello all,
I am running a Stored proc that scrolls through a table creating approximately 500 web pages. I am calling sp_makewebtask from within the cursor looping the data (yes i know a ick....a cursor). The procedure works fine for me on Query analyzer as SA.

My Supervisor wants the SProc to be called from a Web Page for the Content person to have the ability to rebuild the pages on demand.

When the SProc is called I get "Only members of the sysadmin role can execute this stored procedure. "

How can I give the First Stored proc permission to call the second (sp_MakeWebTask)

All help will be appreciated.


Bassguy

 

[EBrownSQL]

I suggest you check the permissions on your stored procedure. Also, is dbo the owner of the stored procedure. If all this is correct, check the database role for the user trying to execute the stored procedure.