Abstract
This chapter steps back and reviews best practices for SQL Server security, with a focus on Dynamic SQL and its typical use cases. Security is an immense topic, one that could easily consume thousands of pages given the opportunity. It also evolves with each day that passes, as new products are released and vulnerabilities are found in older ones. The goal here is to cover the most important and common places in which you need to take care while developing database solutions using Dynamic SQL, without veering too far into one-offs or edge cases.
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
© 2016 Ed Pollack
About this chapter
Cite this chapter
Pollack, E. (2016). Permissions and Security. In: Dynamic SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1811-2_4
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1811-2_4
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1810-5
Online ISBN: 978-1-4842-1811-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books