Abstract
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 regulatory compliance with security reports, such as Data Discovery and Classification and Vulnerability Assessment.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Peter A. Carter
About this chapter
Cite this chapter
Carter, P.A. (2019). SQL Server Security Model. In: Pro SQL Server 2019 Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5089-1_10
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5089-1_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5088-4
Online ISBN: 978-1-4842-5089-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books