Security Enhancements

SQL Server 2014 provides a number of security related enhancements as follows:

Image CONNECT ANY DATABASE—A server-level permission that allows a login to connect to all databases that currently exist and any new databases that are created in the future.

Image IMPERSONATE ANY LOGIN—A server-level permission that allows a middle-tier process to impersonate the account of clients connecting to the database.

Image SELECT ALL USER SECURABLES—A server-level ...

Get Microsoft SQL Server 2014 Unleashed 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.