Abstract
SQL Server 2014 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.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Peter A Carter
About this chapter
Cite this chapter
Carter, P.A. (2015). SQL Server Security Model. In: Pro SQL Server Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0710-9_9
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0710-9_9
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0711-6
Online ISBN: 978-1-4842-0710-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books