SQL Management Studio Shows All Databases

This has "bugged" me for awhile. When you log into any version of SQL (2000, 2005, and even 2008) as a user with restricted access to just a single database (or even a few databases), you can still see a complete list of all the databases on that server. There have been times when I needed to share a database with a customer or have accessed a shared database at a host such as DiscountASP.net or GoDaddy and can see all of the customers on that one box. It's more of a nuisance than a real threat but I really wish it was changed. It has been confirmed as a bug. Please vote for it at http://tinyurl.com/6pk74q.

Published Wednesday, May 21, 2008 4:35 PM by Jason N. Gaylord
Filed under:

Comments

# Database Management » Blog Archive » SQL Management Studio Shows All Databases

Pingback from  Database Management  » Blog Archive   » SQL Management Studio Shows All Databases

# re: SQL Management Studio Shows All Databases

Wednesday, May 21, 2008 6:31 PM by Ken Cox [MVP]

Voted!

# SQL Management Studio Shows All Databases

Wednesday, May 21, 2008 8:14 PM by No1 Microsoft Fan

Looks like I'm not the only one. Jason N. Gaylord Blogged about something today that has bugged me

# re: SQL Management Studio Shows All Databases

Wednesday, May 21, 2008 8:20 PM by wisecarver

blogcastrepository.com/.../sql-management-studio-shows-all-databases.aspx

# re: SQL Management Studio Shows All Databases

Wednesday, May 21, 2008 8:41 PM by rajbk

I have voted too. MS released a modified sp_MSdbuseraccess for SQL 2000.

support.microsoft.com/.../en-us

Not sure why it is not built in by default in 2005.

Raj

# management studio

Thursday, May 22, 2008 3:18 AM by management studio

Pingback from  management studio

# re: SQL Management Studio Shows All Databases

Thursday, May 22, 2008 9:44 AM by Colt

Totally agree with you Jason

# re: SQL Management Studio Shows All Databases

Thursday, May 22, 2008 10:29 AM by rajbk

I did some more digging into this. There is a new permission called VIEW ANY DATABASE.

msdn.microsoft.com/.../ms189077.aspx

Hope that helps.

Raj Kaimal

# re: SQL Management Studio Shows All Databases

Friday, May 23, 2008 7:41 AM by Vimpyboy

Voted.

This is really annoying!

# re: SQL Management Studio Shows All Databases

Wednesday, February 25, 2009 8:31 AM by Waseem Sindhu

I thought i missed something while configuring user access :P

Leave a Comment

(required) 
(required) 
(optional)
(required)