I am not sure if what I want is possible but here we go.
At work we have a dedicated SQL Server 2008 box that host the various databases that we need to run. We have a remote person (lets' call them Bob) who needs to host a database on it. I have been asked to limit Bob's access to the SQL box but give him just enough access to control his database.
Currently I have setup a SQL login for Bob and made it the dbowner of Bob's database and not given access to anything else. When I login with Bob's SQL login to SSMS I can see all the other databases but can only access Bob's. I can, however, access and play with the master database which doesn't feel warm and fuzzy to me.
Is there a way to prevent Bob from seeing the names of the other databases and prevent him from having access to the master database?