O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

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

Managing server-level securable and database-level permissions

The security for an SQL Server instance and database is mainly about managing permissions. These are tied to principals and are securable at a granular level that provides a greater flexibility and control.

To manage the server-level securable and database-level permissions, it is essential to know how the SQL Server control access is managed. The top level of the hierarchy is server scope, which contains logins, the database, and endpoints. The next level is managed on the database scope, which is contained within the server scope that controls securables such as database users, schemas, and roles. The bottom level for permissions is the schema scope that controls the schema itself ...

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