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 for SQL Server 2012, so well done Microsoft for responding!
User defined server roles
Roles can already be created at the database level, but now SQL Server allows roles to be created at the server level too. This allows a finer level of control...
