Hide SQL DB's Users do Not have Access to

In the Login Properties, you can map the user to the database(s) they should access to. For example, if you have three databases A, B and C, you want the user1 only to access to B, in the User Mapping of the Login Properties, you check the database B for that user and uncheck the other databases.

"View all DB's" is an "all or nothing"

They still can change the context to an other database, but they "see" only the current database.

The test user account already had DB mapping. What is odd is they can see the Master and TempDB's. They cannot see their DB but can run queries against it. They need to see the DB since they do not know all the DB names. Is their any way to hide other DB names?

Make sure the user has the right to view the databases:

USE [master];  
GO  
GRANT VIEW ANY DATABASE TO [TestUser];
GO

Hi @rr-4098,

Thanks for your information.

Here is my database for test.

I checked the database properties, it has my domain\user account as the owner, because I created it.

Then I created a Test account with login to allow me to connect into SQL Server (Using SQL Authentication and the Test login)

During I created the account, I Use the server level login (Test) to set its Mappings to include the Test database.

Here you can see what my Test sees at the server level (everything) while it throws an error if I try to access any database.

However, when Test tries to access a database that it is mapped to, it can see the objects inside that database that have been granted to it under database user's Securable permissions.

Please feel free to share the issue more detailed here If you have any other questions, thank you.

Best regards,

Lucy Chen

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications