MS SQL Tighten Security Script

This script can be run on your Microsoft SQL server if you wish to tighten security.

Instead of giving dbowner rights (full MS SQL rights) to the user, you can create roles that have nothing but execute rights on stored procedures and read/write rights on the tables.

Read more about this in the installation section.

Download MS SQL Tighten Security Script:

Sitecore 5.1.0.x: SQL script, 2 Kb
Sitecore 5.1.1.8: SQL script, 2 Kb
Sitecore 5.2.x: SQL script, 1 Kb
Sitecore 5.3.x: SQL script, 1 Kb

For more information about security setting for MS SQL in CMS 6.x, see the CMS 6.x Installation Guide, section "Creating a Database Account for Sitecore CMS Databases on SQL Server".