Don't list databases unless current user has permission to access them
Currently, when accessing SQL server 2008 using the Management Studio and expanding the dabase list, all databases are listed, even though the current user does not have permission to see most of them.
This also has the effect of not listing anything if one does not remove the additional columns from the "explorer details" window, if the user does not have permission to a database.
Upvotes: 3<=-=Sep 13 2010 9:25PM=-=>
Thanks for providing the feedback! We will look at addressing this in the next release of SQL Server. I’m resolving this as a duplicate of Feedback ID: 345379. You can view this at http://connect.microsoft.com/SQLServer/feedback/details/345379/display-only-sql-server-objects-that-you-have-access-to.
Connect has been disabled... Where is this now? We would love to see this fixed.