O'Reilly logo

Tribal SQL by Matt Velic, David Tate, Shaun J Stuart, Wil Sisney, Mark S Rasmussen, Bob Pusateri, Dev Nambi, Colleen Morrow, Stephanie Locke, Chuck Lathrope, Tara Kizer, Kevin Feasel, Diana Dee, John Barnett, Dave Ballantyne

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server Security 101

Diana Dee

In theory, SQL Server security sounds simple. We grant permissions to the people and processes that need access to our SQL Server instances and databases, while controlling which data they can access and what actions they can perform.

However, behind this simple statement lies much complexity. In practice, it is easy for the novice database administrator (DBA) to get lost in the hierarchy of principals, securables and permissions that comprise the SQL Server security architecture. The most common result is the path of least resistance, where people end up with “too many privileges.” They can access data they shouldn't be able to see; they can perform actions they have no need to perform. Most people may be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required