This PR updates the PostgreSQL module to generate a new user at binding time, instead of returning the administrator credentials. The new user is granted privileges to the database at bind time, and when unbinding the privileges are revoked and any objects owned by the user are reassigned to the administrator. The implementation is intended to be similar to the SQLDB one.
Thanks for the cool PR, @tomconte! This is a great change to push PostgreSQL module forward. I'll merge it once the integration test passes in my side.
This PR updates the PostgreSQL module to generate a new user at binding time, instead of returning the administrator credentials. The new user is granted privileges to the database at bind time, and when unbinding the privileges are revoked and any objects owned by the user are reassigned to the administrator. The implementation is intended to be similar to the SQLDB one.