SQL server 2000 Security

Source: Internet
Author: User

/**

*
SQL server 2000
Security

*/

 

--
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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.