I need to provide the access to a database to a user. This user need to see only assigned databases which is mapped to his account but not all the databases(It means I have multiple databases on same server which I cant explore to this user). I'm using SQL server 2017 and 2016 developer editions.
Answer by anthony.green ·
You will need to play with the "View Any Database" permission, by default this is granted to public, so you will need to remove that. This then will revoke the right on all users on the server so you will then need to grant it back to the people who need it, leave it off from the people who don't need it.