Hi;

I'm not a DBA.

I'm working with some people who are running Microsoft SqlServer
2005. Right now, when people log into management studio, they see a
list of every single database, whether or not they have read writes.

They can't actually get into the database.

However, since we have so many databases I think it would be useful to
have the tree on the left of management studio show only databases
that the users have at least read access too.

Is there a setting somewhere to achieve this?

Thanks in advance

Steve

steve (tinker123 (AT) gmail (DOT) com) writes:
Not really. You say

REVOKE VIEW ANY DATABASE TO <login>

However, if you do this, people will only see the system databases and
databases they are owner of. For the rest, they will be fumbling in a
dark room.

And, no, it is not any better in SQL 2008.

But you can vote here on Connect to nag Microsoft a little more
about it:
https://connect.microsoft.com/SQLSer...dbackID=273830


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Dec 10, 5:26*pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
Thanks for the quick and useful reply. I will vote. From a security
perspective I'm surprised they allowed this.