Schema manager create roles on migration
Now that we have the ability to define a schema manager user to use instead of the default, we can quite safely allow this user to create other roles. Normally this would be just the one role but I will allow it to create any number of roles in case there are other database environments defined and they are not used in schema management.
This will be defined in the database config as:
{
"driver": "pgsql",
...
"manager": {
"user": "postgres",
"password": "password",
"roles": [
{
"name": "user_name",
"password": "user_password",
"privileges": "LOGIN"
}
]
}
}