Schema manager create roles on migration

jamie commented

2022-10-28 01:54:35 +00:00

(Migrated from git.hazaar.io)

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"
      }
    ]
  }
}

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: ```json { "driver": "pgsql", ... "manager": { "user": "postgres", "password": "password", "roles": [ { "name": "user_name", "password": "user_password", "privileges": "LOGIN" } ] } } ```

jamie commented

2022-10-28 01:54:35 +00:00

(Migrated from git.hazaar.io)

assigned to @jamie

jamie commented

2022-10-28 01:54:39 +00:00

(Migrated from git.hazaar.io)

created branch 89-schema-manager-create-roles-on-migration to address this issue

created branch [`89-schema-manager-create-roles-on-migration`](/hazaar/hazaar-dbi/-/compare/master...89-schema-manager-create-roles-on-migration) to address this issue

jamie commented

2022-10-28 01:54:44 +00:00

(Migrated from git.hazaar.io)

mentioned in merge request !57

jamie (Migrated from git.hazaar.io) closed this issue

2022-10-28 03:10:11 +00:00

Rows
Columns

Schema manager create roles on migration #89