have a web hosting service that is using MS SQL Server 2005 Express Edition. I have enabled remote database access , but I want to set permission for users so that when they login to Management studio they just see their database not all databases that I have on server. How can I set this up?
deny the 'view any database' permission to the login.
DENY VIEW ANY DATABASE TO [userlogin]
To do this for all logins into the database server, then revoke the view any database permission from the public role
REVOKE VIEW ANY DATABASE FROM [public]