I have an SQL Server with several users and databases. The permissions are imho simple:
- user1 is db_owner of user1_db1
- user2 is db_owner of user2_db1
- user3 is db_owner of user3_db1
- user3 is db_owner of user3_db2
If a user logs in to the server with Management Studio, he sees all databases. He has no rights on it (obviously OK). But he sees them. Which is not optimal.
How can I setup the SQL Server, that when a user logs in, he only gets the databases in which he is db_owner?