Increase user granularity and allow creating more than the 3 built in user accounts.
Increase user granularity and allow creating more than the 3 built in user accounts. For example, we have an offshore development team that would like access to their SQL instance, but can’t have access to any other instances. What I would like to do is to be able to create an account, assign permissions to that account against databases or instances, limiting the access they have to production systems. If we could get it to use AD integration rather than forms authentication as well as being able to set permissions granularly then that would be ideal.
It would be great to have more granular security. The ability to grant a role/group/user to only be able to view a Server Group would be helpful. Ex: allow the dev team access to view the Dev Group of Servers.
Blaž Dakskobler commented
Yes please. Would like to give SQL Monitor access to some teams/people, but only for particular instances or even just databases.
Joe Cairns commented
Absolutely support this one. Our organization will not allow some of the technical teams access to SQL Monitor until a feature like this available and this is from a PCI compliance perspective. Without being able to show what rights and individual user has and to be able to log their activity in the tool, we cant be compliant.
As it stands the user roles aren't much use as we also want to assign permissions to certain databases to certain users.
Thanks for your feedback Andy.