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?
Sql-server – on SQL Server 2005 user can see just his/her database not all
sql serversql-server-2005
Best Answer
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