]> git.somenet.org - root/pub/somesible.git/commitdiff
roles/util/postgres-db-usr/tasks master activeVersion
authorSomeone <someone@somenet.org>
Thu, 19 Nov 2026 18:02:48 +0000 (19:02 +0100)
committerSomeone <someone@somenet.org>
Thu, 19 Nov 2026 18:02:48 +0000 (19:02 +0100)
roles/util/postgres-db-usr/tasks/main.yml

index 61392f0525013595e04b0f01dc91346323c94b72..dd128a07614dba787fc7cf30b2b391235a3a6339 100644 (file)
     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