/** * SQL server 2000Security */
-- Access to the Registry extended stored procedure is prohibited, and the corresponding xpstar. dll file of the extended process is deleted at the same time (deleting this file affects task scheduling) Use Master Revoke Execute On Xp_regread from Dbo Revoke Execute On Xp_regread from Guest -- Prohibit public from executing sp_runwebtask Use Master Revoke Execute On Master. dbo. sp_runwebtask from Public -- Prohibit public from accessing stored procedures for creating SQL proxy tasks Use Msdb Revoke Execute On Msdb. dbo. sp_add_job from Public Revoke Execute On Msdb. dbo. sp_add_jobstep from Public Revoke Execute On Msdb. dbo. sp_add_jobserver from Public Revoke Execute On Msdb. dbo. sp_start_job from Public -- Enable Logon Audit Procedure Enterprise Manager-right-click Server icon-properties-security-audit level select all-Restart -- Enable C2 audit Mode Restart required Use Master Exec Sp_configure 'Show Advanced option ', '1' Reconfigure Exec Sp_configure 'c2 Audit mode ', '1' Reconfigure -- Delete A guest Account Use Master Go Sp_dropuser guest Go |