SQL Rights Issue

From: C.P. (craig_parrish_at_dontspamme.hotmail.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 12:36:04 -0700

We have a custom program that is calling the extended stored procedure xp_cmdshell. The only way we've been able to get it to successfully run is by giving the user the System Administrator server role.

We tried setting the user up to have the DBO role on the master database and giving the user exec rights to xp_cmdshell, but that still did not allow it to run.

We don't want to assign the System Administrator role to every user who has to run this program. What alternatives do we have?

Thanks in advance for your help.

If you would, please email me with posting to this, I might not be able to find my way back again :)

craig_parrish@snipthispart.hotmail.com