Hello,
We have a need since we manage many practices on separate databases with the same user groups across all of them, where if a decision is made to change the permission of a particular group, someone has to go to each one and do a manual change, or via a SQL query on each database (which is tedious, time consuming, and not safe).
We are requesting that a GET and PUT command be available for the Permissions of the User Groups to return all the current permissions of a group (via group number from UserGroups GET) and then the option to PUT and update the User Group Permissions so that we can update databases on bulk.
Please let me know if there are any questions.
Thank you
User Group Permissions Request for GET & PUT
Re: User Group Permissions Request for GET & PUT
Hello rgibbons,rgibbons wrote: ↑Wed Jun 18, 2025 12:42 pmHello,
We have a need since we manage many practices on separate databases with the same user groups across all of them, where if a decision is made to change the permission of a particular group, someone has to go to each one and do a manual change, or via a SQL query on each database (which is tedious, time consuming, and not safe).
We are requesting that a GET and PUT command be available for the Permissions of the User Groups to return all the current permissions of a group (via group number from UserGroups GET) and then the option to PUT and update the User Group Permissions so that we can update databases on bulk.
Please let me know if there are any questions.
Thank you
Creating a user and assigning them to a user group is one thing, but managing permissions for those groups is a separate layer of complexity. At this point, we haven’t committed to exposing group permission management via the API, and it’s not clear yet if that’s something we’ll pursue.
However, you can view the current permissions for a user group by querying the grouppermission table using the /shortquery endpoint.
Out of curiosity, how often are you needing to update group permissions across multiple databases?
Thanks!