From 842db1868a9d4b690a9fbd8f3719032f73910c10 Mon Sep 17 00:00:00 2001 From: Someone Date: Thu, 19 Nov 2026 19:02:48 +0100 Subject: [PATCH] roles/util/postgres-db-usr/tasks --- roles/util/postgres-db-usr/tasks/main.yml | 11 +++++++++++ 1 file changed, 11 insertions(+) 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 -- 2.47.3