2

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.

Improve this question
1
  • To understand what a listener is and why you see all databases (event the one does not belong to that Availability Group/Listener) see this question.
    – SqlWorldWide
    Commented Aug 3, 2018 at 14:36

1 Answer 1

Reset to default
3

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.

Improve this answer
1
  • ok thanks. I thought so and now it is confirmed.
    – Mirza Baig
    Commented Aug 2, 2018 at 21:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.