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 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.
