SQL 2005 - Only listing databases you have permission to

[ErrolDC2]

How do I limit the list of databases seen in SQL 2005 to only those a user has permissions to? For example, in STM, when a user logs in, they see all databases. How does one limit this?

Thanks,

 

[mrdenny]

Did you enable the guest account in the user databases?

Denny
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