June 2015
Intermediate to advanced
1800 pages
70h 6m
English
Several new security enhancements have been added to SQL Server 2014 to help make it more secure than any prior version. These enhancements build upon the myriad of security-related changes made in the three prior versions and follow the policy of “least privileges” that Microsoft has been pushing. Several of these new changes follow:
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.
IMPERSONATE ANY LOGIN—A server-level permission that allows a middle-tier process to impersonate ...
Read now
Unlock full access