SQL 2012 users can only view their own databases

Take SQL Server 2012 as an example

The figure above shows screenshots of some databases.

  
  
   

    

     
The code is as follows:
     
Copy code
 
    
 
    

     
Deny view any DATABASE to PUBLIC;
 
    
   
  
Then run the command for the Best user of the Best database.

  
  
   

    

     
The code is as follows:
     
Copy code
 
    
 
    

     
Alter authorization on database: Best TO Best
 
    
   
  

The Best user in the resource manager can only display the Best database after logging on to the database, and the same SQL statement is executed for the Mine user in the database.

  
  
   

    

     
The code is as follows:
     
Copy code
 
    
 
    

     
Alter authorization on database: Mine TO Mine
 
    
   
  

After logging on to the database, the Mine user can only display the Mine database, which achieves the goal. When assigning permissions, remember to map the permissions of the corresponding database to the corresponding user to prevent cross-database operations.