The SELECT ALL USER SECURABLES Permission in SQL Server 2014

The SELECT ALL USER SECURABLES permission in SQL Server 2014 is a very useful new server-level permission. The login that gets granted this permission, can view the data in all databases that the user can connect to. For example, consider a scenario where you have the following three databases: db1 db2 db3 Each database has … Read more…