Chapter 8. Administering SQL Server Security and Authorization
By maintaining a strategy that is secure by design, secure by default, and secure in deployment, SQL Server 2012 allows for a much more effective method of design, implementation, and administration of security across resources and services provided by the SQL environment. Security permissions can be defined on a wide range of objects, from network endpoints that facilitate client communication, to execute permissions on a stored procedure, even down to the column level within a table. Complex security implementations can be efficiently controlled with granular role-based authorization and database schemas.
Administering SQL security is a key database administrator task that normally ...
Get Microsoft® SQL Server 2012 Management and Administration, Second Edition 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.
