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.
To do this for all logins into the database server, then revoke the view any database permission from the public role