Due to company policies, the API keys must be renewed every month. But since the generation of api-keys is a manual process that each user must perform, we cannot guarantee renewal. We want to be able to modify existing api-keys or create new api-keys programmatically and send them securely to our users.
Today we have the rstudio connect database configured with postgres, and we can see that we could modify the key column of the api-key table. However, this column is encrypted.
We want to know if there is any way to do it.