Home 2015 November SQL Server: Script to Hide all Databases in SSMS

SQL Server: Script to Hide all Databases in SSMS

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing the script to hide all databases from the all public logins in SQL Server Management Studio.

We are hiding all databases for security reasons. Using below script, you can hide all databases for all user logins.

Once you execute below 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.

Anvesh Patel
MySQL: How to Log General and Long Running Queries into Log TableSQL Server: Script to List all Dynamic Management Views and Functions
Comments: 3
  1. mackie
    December 6, 2015 at 7:52 pm

    This is a great tip particularly to thopse fresh to
    the blogosphere. Simple but very precise info…
    Thank you for sharing this one. A must read article!

  2. maulen
    January 22, 2016 at 1:08 am

    Thanks on your marvelous posting! I genuinely enjoyed reading it, you are a great
    author. I will be sure to bookmark your blog and definitely will come back someday.
    I want to encourage you to continue your great writing, have a nice
    morning!

  3. Maria
    March 31, 2016 at 8:16 am

    hi!,I like your writing so so much! proportion we keep in touch extra approximately your article on AOL? I need an expert on this space to resolve my problem. Maybe that’s you! Looking ahead to look you.

Anvesh Patel
Anvesh Patel

Database Engineer

November 16, 2015 SQL Server, SQL Server DBA Script, , , , , , , , , ,