Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Hide Databases from SSMS

Mar 14 2013 12:00AM by Alpesh Patel   

We can easily restrict the access of database using Logins but to hide it's tough.

SQL Server has feature to hide all databases from SSMS.

To do that follow the steps.

  1. Create or Go to Property of existing Login.
  2. Move to Securable tab.
  3. In permissions grid check deny in line of "View any database"
  4. Login using that user.
  5. See you will not see any database
Read More..   [32134 clicks]

Published under: SQL Server Tips · SSMS Tips ·  ·  · 


Alpesh Patel
36 · 5% · 1662
4
 
1
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

5  Comments  

  • Good tip. Just keep in mind that it won't help if someone has "SA" privs. In other words, you can't use this to hide databases from most DBAs or other system admins.

    commented on Mar 14 2013 2:54PM
    Jeff Moden
    161 · 1% · 306
  • Since you can no longer see any databases, can you grant permission to view/list individual databases?

    After denying "view all databases", I can't see any databases other than master and tempdb. Opening a new query, I can explicitly issues "USE [HiddingDatabase]" and successfully issue queries. But I'd like to see [HiddenDatabase] show up in the Object Explorer.

    commented on Mar 14 2013 11:37PM
    Marc Jellinek
    96 · 2% · 586
  • Good tip....

    commented on Mar 15 2013 12:16AM
    Nirav Gandhi
    38 · 5% · 1567
  • How can we Hide the databases user wise?

    commented on May 30 2013 12:25AM
    Nirav Gandhi
    38 · 5% · 1567
  • @Nirav I think this could be achieved by "Contained Database".

    commented on Aug 24 2013 12:07AM
    Shivendra Kumar Yadav
    61 · 3% · 936

Your Comment


Sign Up or Login to post a comment.

"Hide Databases from SSMS" rated 5 out of 5 by 4 readers
Hide Databases from SSMS , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]