Hi,
I’m new to Render and I’m trying to deploy my application which uses a custom schema.
I have multiple accounts for the app.
- The runtime account can only add / edit records but not delete anything
- the maintenance account can delete records
- the schema account 1 manages schema changes
On plain vanilla postgres, I can use ALTER DEFAULT PRIVILEGES IN SCHEMA to automatically make all changes in the schema visible to my other accounts.
This does not seem to work with Render due to limited privileges on the accounts provided.
What’s the best alternative to make all changes visible?