MS SQL Server - SQL server proxy acct

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL server proxy acct

mecn

2006-11-15, 7:14 pm

hi,
We have sql2k sp4 prod.
Need a sql login to run master.xp_cmdshell..

That user muct be sysadmin. could we have a non-sysadmin sql user to run the
master.xp_cmdshell.
Is that Proxy acct must be a windows user? A sql user would be ok. if yes.
what kind of impact that I would have by using sql proxy acct instead
sysadmin for a sql user?

Thanks

Sponsored Links