Security Question = xp_Cmdshell  
Author Message
Venkat





PostPosted: Mon Nov 28 09:26:49 CST 2005 Top

SQL Server >> Security Question = xp_Cmdshell

All,

Thanks for reading this.

I have read that you must have some kind of Admin permissions to use
the Xp_Cmdshell procedure.

Is there a way to set up a normal user to be able to execute this with
out giving them a host of special functions?

Doug

SQL Server178  
 
 
Jens





PostPosted: Mon Nov 28 09:26:49 CST 2005 Top

SQL Server >> Security Question = xp_Cmdshell No thats not possible, in the XP_cmdshell you have the BIT principle,
in or out. You could put your own capsulated procedure around that
which checks wheter the command the user is issueing is allowed for him
checking this with some kind of substring, but there is n builtin
functionality for that.

HTH, jens Suessmeyer.

 
 
Armando





PostPosted: Mon Nov 28 09:32:38 CST 2005 Top

SQL Server >> Security Question = xp_Cmdshell You can work around it by setting up a SQL Server proxy account

http://support.microsoft.com/default.aspx?scid=kb;en-us;890775




> All,
>
> Thanks for reading this.
>
> I have read that you must have some kind of Admin permissions to use
> the Xp_Cmdshell procedure.
>
> Is there a way to set up a normal user to be able to execute this with
> out giving them a host of special functions?
>
> Doug
>


 
 
douglascfast





PostPosted: Mon Nov 28 10:30:05 CST 2005 Top

SQL Server >> Security Question = xp_Cmdshell All,

Thanks for that. The link is what I need, (I think).

Doug