I need to restrict the list of database for our users in a SQL Instance In order to move forward this I revoked the view any database permission to the user desired. But I figured out that only applies for databases owners so if you have access to a database but noy like db_owner even if for this user you deny "view any database". Keep listed the database on the instance
I would like to know how I can restrict to the users to only see their databases where are owners and also databases where only have access.
USE [MASTER] GO DENY VIEW ANY DATABASE TO [MYACCOUNT] GO