SQL Server 2019 offers a complex security model with overlapping layers of security that help database administrators (DBAs) counter the risks and threats in a manageable way. It is important for DBAs to understand the SQL Server security model so that they can implement the technologies in the way that best fits the needs of their organization and applications. This chapter discusses the SQL Server security hierarchy before demonstrating how to implement security at the instance, database, and object levels. We will also discuss auditing with SQL Audit, and assisting ...
© Peter A. Carter 2019
P. A. CarterPro SQL Server 2019 Administrationhttps://doi.org/10.1007/978-1-4842-5089-1_1010. SQL Server Security Model
Peter A. Carter1
(1)
SOUTHAMPTON, UK
Get Pro SQL Server 2019 Administration: A Guide for the Modern DBA 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.
