When granted, the login that was 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:
Using the visual way, you can achieve this using two steps:
|Step 1: Map the login (db123) to the default schema of DB1, DB2 and DB3|
|Step 2: Grant the login (db123) with the "Select All User Securables" permission|
My Latest Projects:
- DBA Security Advisor: Secure your SQL Server instances against security risks.
- In-Memory OLTP Simulator: Easily benchmark SQL Server's In-Memory OLTP Engine against your custom workload.
- Artemiou SQL Books: Download my latest free books on SQL Server.
- Artemiou Data Tools: See my latest software projects.