Does anyone know how to filter the list of databases when using SQL Management Studio Express?  More specifically, how to only show databases that your username has access to?

I've found how to filter the list of tables within a database, but that filter button is greyed out when at the database node/level.

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

Anybody got any ideas?

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

Hello,

 

Normally, you should only see the tables you own !! If you see other tables (like mine!!), this is not normal at all.... Ultima Mark, could you please check this ???

 

DV

I see all of the databases, but you are correct that I can only see tables in my own databases (no worry!).  I get an access denied error if I try to open a database I don't have access to (I found that out accidentally).

The problem is my databases are mixed throughout the list and when there are 100-200 databases in the list, it can take a little while to find mine.  It would be nice to only see my own databases in the list so that I only have 5-10 to sort through.

I guess I'll just rename my databases (prepended with underscores) so they appear at the very top of the list (hehehe).

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

Ok, surely this is a security issue?! (Even though no one would probably be able to access my dbs, I don't want others to see what dbs I have).

Can something be done about this - to hide the databases that don't belong to the user who has logged in, or is this just the way it works on a shared server when making a remote connection?

Jits

EDIT:

Ahh... I now understand why other hosts often prevent remote connections.

Unfortunatly, as far as I know about SQL's security, the actual Access Control Lists are stored in the database itself, and not system wide, so when the server provides you a list of databases, it dosent know which ones you have access to...Basically they can only see the name of your database and nothing else...

That made more sense in my head :)

Monty

 

---

Senior C#.net Developer

Hi Monty,

Hmmm, I see what you mean, and although no one else would be able to access your database(s), it's still a bit of nuisance (especially having to scroll through the list of DBs to find yours).

Anyways, it's not huge deal.... thanks for your insight.

Jits
 

I just remembered that this also a problem with SQL 2000 Enterprise Manager (you can see all DB's, not just yours).  I'm guessing since there isn't an "obvious" setting to filter the list of DB's, that it still applies to 2005.

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

Easiest way is to just prefix your DBs - I do that on ultima hosts, and makes things easier, for me anyway :)

Monty
 

---

Senior C#.net Developer

Yeah, that's what I've started doing now.  :-)

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com