Feb 02, 2009
Download Configuring access to SQL Server data and features is an important part of every DBA's job, but one that we all know must be handled carefully. The unintended consequences of giving too much access to resources can mean compromised or lost information. There are two important goals to keep in mind when configuring security for SQL Server: to protect the integrity of our data and prevent unauthorized access to it. There are many factors to consider when configuring security on a SQL Server. It's easy to overlook some of them, but if you use a systematic approach and factor in all four levels of security - server, database, schema, and object - the chances of missing something along the way become minimized.