Chapter 33
Authorizing Securables
In This Chapter
Building Permission Chains
Understanding Object Ownership and Security
Using Fixed and User-defined Roles
Managing Views and Security
This chapter adds another important piece to the SQL Server security puzzle — securables. They include server and objects including databases, tables, and views that you can secure to prevent unauthorized access.
You can perform most security management in SQL Server Management Studio using T-SQL code to grant, revoke, and deny access, through the Data Control Language (DCL) commands and several system-stored procedures.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
