In SQL Monitor, I want to...

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.

85 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Andy LambAndy Lamb shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Rich JamesRich James shared a merged idea: Per Server Authentication  ·   · 
    RussRuss shared a merged idea: Have the ability to add roles/users and grant rights to server groups.  ·   · 
    Berlington BarnettBerlington Barnett shared a merged idea: USER ADMINISTRATION  ·   · 

    9 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • William SorannoWilliam Soranno commented  ·   ·  Flag as inappropriate

        I am just starting to use the 14 day trial and the idea of sharing passwords will be a show stopper for a purchase. Having AD integration and being able to specify either an AD group or user makes perfect sense. Andy thank you for the suggestion.

      • Rich JamesRich James commented  ·   ·  Flag as inappropriate

        While useful to split apart the administrative and user accounts, there doesn't seem to be a provision to allow a single server (or group of servers) to be checked from a specific account. It would be useful to have 'subordinate read only' accounts that could only read a subset of the full array of servers, so departmental administrators could see their own system, without being able to see another department's system behaviour.

      • Blaž DakskoblerBlaž Dakskobler commented  ·   ·  Flag as inappropriate

        Yes please. Would like to give SQL Monitor access to some teams/people, but only for particular instances or even just databases.

      • Joe CairnsJoe Cairns commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        As it stands the user roles aren't much use as we also want to assign permissions to certain databases to certain users.

      • Berlington BarnettBerlington Barnett commented  ·   ·  Flag as inappropriate

        Add the capacity to create custom user with general o explicit access to the system, without generic user, and a log access.

      Feedback and Knowledge Base