Sql-server – Hide database from other users in SQL Server 2008

sql serversql-server-2008ssms

I have created a database in SQL Server 2008 and it shows in server object explorer to all users that can login to SQL.

I want to hide it from those users, I want it to be viewable by me only.

How can I do that? Any help, suggestions?

Many thanks

Best Answer

Try this: In SQL Server Management Studio, right click the server and click "Properties". Click on "Permissions" and then select the "Public" role and remove "Grant" from "View Any Database".

Related Topic