diff options
| author |  shtlrs <[email protected]> | 2024-05-15 20:21:56 +0200 |
|---|---|---|
| committer |  Chris Lovering <[email protected]> | 2024-05-16 20:22:19 +0100 |
| commit | 87d603d64cce60bbafc1d04a105d7211ecb248a8 (patch) | |
| tree | bd028b143ba824bc4a1a096c65fe632ddd9f54cc /ansible/roles/postgres | |
| parent | define the blackbox user and its db roles (diff) | |
grant pg users their predefined roles
Diffstat (limited to 'ansible/roles/postgres')
| -rw-r--r-- | ansible/roles/postgres/tasks/main.yml | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/ansible/roles/postgres/tasks/main.yml b/ansible/roles/postgres/tasks/main.yml index 2824a12..ea6565b 100644 --- a/ansible/roles/postgres/tasks/main.yml +++ b/ansible/roles/postgres/tasks/main.yml @@ -57,3 +57,17 @@ - Reload the postgres service tags: - role::postgres + +- name: Grant specified roles to users + community.postgresql.postgresql_membership: + groups: "{{ user.roles }}" + target_role: "{{ user.name }}" + loop: "{{ postgres_users }}" + when: user.roles != None + loop_control: + loop_var: user + label: "{{ user.name }}" + become: true + become_user: "{{ postgres_user }}" + tags: + - role::postgres |