CONTEXT: We want to give our developers access rights to there databases alerts (long running queries, blocking processes, deadlocks ...).

PROBLEM: Access rights are only allowed on sql server instance level. Database1 should only see dev team1, database2 should only see dev team2. This is not possible at the moment.