Security management
There are a number of new enhancements to security in SQL Server 2012. Keeping your data secure is always high priority, so in the following section we will explore how these features can help you and how to put them in place.
Default schemas for groups
You can now define a default schema for a group, which most DBAs use to simplify administration. This avoids implicit schema creation, so when a user creates an object, it is created under the group schema instead of under database owner (dbo). This eases administration and saves objects from being created in the wrong schema. Furthermore, it avoids the possibility of a query using the wrong schema and returning incorrect results. This was one of the most requested security features ...
Get What's New in SQL Server 2012 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.
