Management Studio in 2005.

[joejack0330]

Hi, we'd like to give a user ability to use sql 2005 management studio to connect to a specific database which we have persmissions set and seems to be working. But, they can still see other databases. It looks like they can't do anything to modify or delete but they can still expand master and msdb while any other user created db's, they can't even expand but still show. Is there a way to hide these from even being displayed just to keep them from playing too much?

Thanks, Joe

 

[mrdenny]

In order to remove the other databases from view you would need to remove the guest account from those databases.

It is recommended to not do this.

By default the user doesn't have any ability to do anything in the other databases.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog