From: Someone Date: Thu, 19 Nov 2026 18:02:48 +0000 (+0100) Subject: roles/util/postgres-db-usr/tasks X-Git-Tag: activeVersion X-Git-Url: https://git.somenet.org/root/pub/somesible.git/commitdiff_plain?ds=sidebyside roles/util/postgres-db-usr/tasks --- diff --git a/roles/util/postgres-db-usr/tasks/main.yml b/roles/util/postgres-db-usr/tasks/main.yml index 61392f0..dd128a0 100644 --- a/roles/util/postgres-db-usr/tasks/main.yml +++ b/roles/util/postgres-db-usr/tasks/main.yml @@ -58,3 +58,14 @@ obj: "{{pg_name}}" privs: CONNECT,TEMPORARY role: "grp_spectator" + + +- name: GRANT ALL ON DATABASE "{{pg_name}}" TO "{{pg_name}}" + become_user: postgres + postgresql_privs: + db: "{{pg_name}}" + type: database + obj: "{{pg_name}}" + privs: ALL + role: "{{pg_name}}" + grant_option: true