In this post, I provide one script to hide all databases for all public login in SQL Server Management Studio.
Generally, we are hiding all databases for security reason.
Using this script you can hide all databases for all user logins.
Once you execute this script, you will not be able to see any databases in SQL Server Management Studio. Only the sysadmin login or owner of the database can see the databases in SQL Server Management Studio.
DENY VIEW ANY DATABASE TO PUBLIC
Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.
If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.
I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.