Hide not authorized user databases to logins in SSMS

Recently a few of developers started complaining about 100s of database in one instance, making them difficult to navigate in SSMS. This situation is quite generic in all development environment. So here we are going to do a little trick to hide all the databases in SSMS and show only the ones that are given access to the users.

DO NOT TRY THIS ON PRODUCTION.

hide-user-database-ssms

Prasad Sahoo

Prasad Sahoo, is an enthusiast of Microsoft technologies in general and a passionate database professional, mainly focusing on SQL Server performance tuning and business intelligence. He has contributed a long time of his career working on SQL Server and other RDBMS. If he is not busy with SQL stuff then he must be watching some Hollywood movies.

%d bloggers like this: