aboutsummaryrefslogtreecommitdiffstats
path: root/ansible/roles/postgres/tasks
diff options
context:
space:
mode:
Diffstat (limited to 'ansible/roles/postgres/tasks')
-rw-r--r--ansible/roles/postgres/tasks/main.yml17
1 files changed, 17 insertions, 0 deletions
diff --git a/ansible/roles/postgres/tasks/main.yml b/ansible/roles/postgres/tasks/main.yml
index fb026c1..8a210be 100644
--- a/ansible/roles/postgres/tasks/main.yml
+++ b/ansible/roles/postgres/tasks/main.yml
@@ -72,6 +72,23 @@
tags:
- role::postgres
+- name: Grant specified grants to particular roles
+ community.postgresql.postgresql_privs:
+ database: "{{ grant.database }}"
+ state: "{{ grant.state }}"
+ privs: "{{ grant.privs }}"
+ objs: "{{ grant.objs }}"
+ roles: "{{ grant.roles }}"
+ when: postgres_grants is defined
+ loop: "{{ postgres_grants }}"
+ loop_control:
+ loop_var: grant
+ label: "{{ grant.privs }} --> {{ grant.roles }}"
+ become: true
+ become_user: "{{ postgres_user }}"
+ tags:
+ - role::postgres
+
- name: Import postgresql.conf
copy:
src: postgresql.conf