A-A+
sql 2005限制危险扩展存储过程
网上很多文章介绍SQL 2005 安全配置的文章，都有提到删除扩展存储过程。笔者也试了，删除不了。
有文章说到，sql 2005 的扩展存储过程是不能删除的。只能设置权限。下面是语句：
deny execute on sp_makewebtask to public
deny execute on xp_cmdshell to public /*命令行*/
deny execute on xp_dirtree to public /*可以展开你需要了解的目录，获得所有目录深度*/
deny execute on xp_fileexist to public /*用来确定一个文件是否存在*/
deny execute on xp_getnetname to public /*可以获得服务器名称*/
deny execute on xp_terminate_process to public
deny execute on sp_oamethod to public
deny execute on sp_oacreate to public
deny execute on xp_regaddmultistring to public
deny execute on xp_regdeletekey to public
deny execute on xp_regdeletevalue to public
deny execute on xp_regenumkeys to public
deny execute on xp_regenumvalues to public
deny execute on sp_add_job to public
deny execute on sp_addtask to public
deny execute on xp_regread to public
deny execute on xp_regwrite to public
deny execute on xp_readwebtask to public
deny execute on xp_makewebtask to public
deny execute on xp_regremovemultistring to public
deny execute on sp_OACreate to public
deny execute on sp_addextendedproc to public
deny execute on xp_cmdshell to public /*命令行*/
deny execute on xp_dirtree to public /*可以展开你需要了解的目录，获得所有目录深度*/
deny execute on xp_fileexist to public /*用来确定一个文件是否存在*/
deny execute on xp_getnetname to public /*可以获得服务器名称*/
deny execute on xp_terminate_process to public
deny execute on sp_oamethod to public
deny execute on sp_oacreate to public
deny execute on xp_regaddmultistring to public
deny execute on xp_regdeletekey to public
deny execute on xp_regdeletevalue to public
deny execute on xp_regenumkeys to public
deny execute on xp_regenumvalues to public
deny execute on sp_add_job to public
deny execute on sp_addtask to public
deny execute on xp_regread to public
deny execute on xp_regwrite to public
deny execute on xp_readwebtask to public
deny execute on xp_makewebtask to public
deny execute on xp_regremovemultistring to public
deny execute on sp_OACreate to public
deny execute on sp_addextendedproc to public
评论已关闭！