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

Share
Tweet
Share
Share

About the Author

Previous Post Large MSDB Database From sysmaintplan_logdetail Table Next Post SQL Server Column Level Encryption and Query Performance
>
The owner of this website has made a commitment to accessibility and inclusion, please report any problems that you encounter using the contact form on this website. This site uses the WP ADA Compliance Check plugin to enhance accessibility.