SQL Server Security Model
Peter A. Carter · Apress eBooks · 2019
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.