From 537b387f86f604c501d7294e47518f086ef33bf8 Mon Sep 17 00:00:00 2001
From: Someone <someone@somenet.org>
Date: Thu, 21 Aug 2025 00:57:35 +0200
Subject: [PATCH] roles/util/postgres-db-usr/tasks

---
 roles/util/postgres-db-usr/tasks/main.yml | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/roles/util/postgres-db-usr/tasks/main.yml b/roles/util/postgres-db-usr/tasks/main.yml
index aa65e6e..2495812 100644
--- a/roles/util/postgres-db-usr/tasks/main.yml
+++ b/roles/util/postgres-db-usr/tasks/main.yml
@@ -33,6 +33,7 @@
   become_user: postgres
   postgresql_privs:
     db: "{{pg_name}}"
+    privs: ALL
     state: absent
     type: database
     role: public
@@ -49,10 +50,11 @@
     role: public
 
 
-- name: ensure group grp_spectator has necessary privs on db "{{pg_name}}"
+- name: GRANT CONNECT,TEMPORARY ON DATABASE "{{pg_name}}" TO "grp_spectator"
   become_user: postgres
   postgresql_privs:
     db: "{{pg_name}}"
+    type: database
     obj: "{{pg_name}}"
     privs: CONNECT,TEMPORARY
     role: "grp_spectator"
-- 
2.47.2