I had the same issue here the only solution I could find was to modify my Dockerfile to run as root.
I’m looking into running Hashicorp Vault as my secrets manager instead of the built-in feature to get more control and security. Lack of user roles/permissions in Render (any team member can view/edit without version control) makes storing secrets via the secrets file a poor long term solution.