Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 xp_cmdshell lockdown?

Author  Topic 

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2001-08-06 : 15:25:29
In Robert Vieira's book Professional SQL Server 7.0 (Wrox) he tries to put the fear of mass destruction in you about the xp_cmdshell extended stored procedure, and says you really need to lock it down.

What are your thoughts on this, and what steps need to be taken to "lock it down"? If users are not specifically granted rights to the master db does that handle it?

------------------------------------------------------------------
Contractor$ never die, they just leave for higher-paying project$.
   

- Advertisement -