Chapter 4Security
Unlike the ones that preceded it, this chapter deals with only one subject. Security has many facets, from the exterior of the system (called a surface) to the rights and privileges the users have on the objects the databases contain. Even so, we only scratch the surface (no pun intended) on the tools and features you have at your disposal to secure your system.
Throughout the chapter, I refer to “least privilege,” which is a concept common to secure systems and applications. It means to allow only who is necessary to do only what is necessary, and it is the basis for planning an effective security strategy. In the military, this is called a “need-to-know” basis. In fact, many military concepts carry through to platform and ...
Get Administrator’s Guide to SQL Server 2005 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.
