I need to know a way to setup multiple users on a SQL2000 Server and make sure each user can only see their own database. For example, I setup a login user1, give them DBO access to the database user1DB, and when user1 logs in with Enterprise Manager I want them to only see their own database listed (rather than all DB’s on the server.)
I’ve tried this already, granted the login DBO access only to their own database, but all databases show up in Enterprise Manager when the user logs in. The user doesn’t have rights to other databases, so if they try to open one they get an error, but I’d rather they just didn’t see the other DB’s at all.
