up vote 2 down vote favorite
share [g+] share [fb]

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

link|improve this question
As far as I know, you cannot do this in SQL Server Management Studio. Everyone sees all databases - whether they can use anything inside them or not. – marc_s Mar 10 '11 at 14:21
Just because they can see it, it doesn't mean they can access it. If you need to hide the existence of a database from other users, use a separate server (or instance) – Damien_The_Unbeliever Mar 10 '11 at 14:23
feedback

migrated from stackoverflow.com Mar 11 '11 at 10:02

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 2 down vote

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".

link|improve this answer
+1 neato ! Great tip, thanks! – marc_s Mar 10 '11 at 14:29
feedback

Your Answer

 
or
required, but never shown
discard