Chapter 5

Schemas

Introduction

Schemas are nothing more than containers with a fancy name. They are extremely important, though, because they are integral to the creation of object namespaces in SQL Server, as well as to the administration of ownership and privileges for those objects. Schemas are not new in SQL Server 2005. They did exist in previous versions as required by the SQL specification, but unfortunately, users and schemas were implicitly tied together. In SQL Server 2005, the schemas and users have been separated. There are some very good reasons for ...

Get How to Cheat at Securing SQL Server 2005 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.