Skip to content

Instantly share code, notes, and snippets.

@ediblecode

ediblecode/stop-viewing-all-databases.sql

Created December 15, 2016 08:30
Show Gist options
  • Save ediblecode/d4be5d92780102bce7171c70ae48519d to your computer and use it in GitHub Desktop.
Save ediblecode/d4be5d92780102bce7171c70ae48519d to your computer and use it in GitHub Desktop.
Download ZIP
Stop viewing all databases in SSMS
Raw
stop-viewing-all-databases.sql
USE MASTER
GO
DENY VIEW ANY DATABASE TO PUBLIC
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment