Available in all Editions of SQL Server 2014
- CONNECT ANY DATABASE : Using this permission you can allow a login to connect to any database (existing or future) without having to configure connect privileges on every database.
GRANT CONNECT ANY DATABASE TO sqlrx
GO
- IMPERSONATE ANY LOGIN : This allows a login to impersonate any other login, without giving them sysadmin privileges.
GRANT IMPERSONATE ANY LOGIN TO sqlrx
GO
- SELECT ALL USER SECURABLES : Allows SELECT, but not INSERT/UPDATE/DELETE/MERGE permissions on all user tables in all user databases.
GRANT SELECT ALL USER SECURABLES TO sqlrx
GO