Chapter 13
Securing Data
Information in this chapter
• GRANTing Rights
• DENYing Rights
• REVOKEing Rights
• Column Level Permissions
• Row Level Permissions
• Summary
In this final chapter we are looking at the securing of the data within the SQL Server instance. As you have probably noticed by now, the rest of the chapters in this book are more about securing the network, or the instance, or granting rights through the roles within the database engine. In this chapter we are looking at securing the information within the database at the smallest levels possible such as the row or column level.
By default SQL Server takes a view nothing approach to the data within the databases. In prior versions such as SQL Server 7 and SQL Server 2000 the ...
Get Securing SQL Server, 2nd Edition 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.
