New SQL Server 2014 Permissions

By SQLRx Admin | SQL Server

Jul 08

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

About the Author

>