We are having exactly the same necessity. Unfortunately, the dropdown to show the database environment is broken! I can see that we are receiving the environment in the retool request, but the dropdown is not able to show it. @Tess could you please direct us to a working solution please ?
Hi @Jonathan_C Do you mean the dropdown on the Permissions settings page? Are there any errors in the console? I'm trying to reproduce this for our team, but I'm not seeing the same behavior on my side
It looks like your team is on the Business plan, and you would need to be on the Enterprise plan in order to be able to granularly restrict access to certain environments
I've filed a request to make this distinction more clear in our docs