I have servers with multiple databases which belong to different departments. I want to share some Diagnostic Manager Info with DB owners but not the whole Server Information (i.e. Dashboard).
In application security I can only assign whole servers with users. As multiple users owning DBs are on this Systems I cannot do this. I will share some reports like "Database statistics" or "query statistics" with them. Is there a way to define alerts which are only triggered when metrics of specific databases are affected- like database Status or deadlocks
Or any other way to provide users of shared SQL Servers with diagnostic manager based information which are related to a specific database?
Thanks a lot
Please add this feature request under http://community.idera.com/database-management/product-documentation/i/feature-requests
Is there a need for database level security access to DM or just ability to filter certain alerts for certain databases?
I just want to filter alerts for databases. At the Moment I use reports "database statistics" to provide some informations to DB Owners. It seems to me that I can´t add a Feature request, I got no "new" button
Feature Request: http://community.idera.com/database-management/product-documentation/i/feature-requests/add-users-based-on-databases