How to hide database in management studio?

Question

How to hide database in management studio so that only owner of database can access it?

Nanddeep Nachan · Answer

Sysadmin being fixed server role can perform any activity in the server. Sysadmin is kind of super power admin. You may setup a separate database instance on the same server.

Ranjit Powar · Answer

I have tried that but if user is from sysadmin group then he can access database. How to deny sysadmin from using database.

Nanddeep Nachan · Answer

Revoke the permission 'VIEW ANY DATABASE' from the role PUBLIC For more details please see article here: https://www.mssqltips.com/sqlservertip/2995/how-to-hide-sql-server-user-databases-in-sql-server-management-studio/