Hide databases from SQL Server with AG

by Mirza Baig   Last Updated August 02, 2018 22:06 PM

I have 10 databases on a server. Each database is part of a different AG. Each database has its own listener. Can I hide all databases and show only the one database belonging to a listener? I also do not want to create a separate user for each listener as it will be a lot of users to be created and maintained across many database servers.



Answers 1


Can I hide all databases and show only the one database belonging to a listener?

Yes. Have each AG's databases owned by a separate login created specifically for that purpose.

I also do not want to create a separate user for each listener

Then no. There's no way to trim the list of databases a user can see based on the endpoint used to connect to SQL Server.

David Browne - Microsoft
David Browne - Microsoft
August 02, 2018 21:41 PM

Related Questions