Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Restrict remote clients from viewing certain DBs

Author  Topic  JLemire Starting Member 2 Posts Posted - 2001-01-05 : 17:43:01 Could anybody tell me how I restrict users from viewing certain databases when using the MMC? Example: I have 10 databases on SQLServer and I want a certain login to view only the one he has permissions to. Currently, this user can view all users and databases. Although he can't modify any of the databases or users, he can still view them. How do I prevent this from happening. I am SURE that I am missing something. If anyone can point me in the right direction, it would be greatly appreciated. TIA!