fedora-infra / ansible

Clone
Source Code
GIT

#1356 [postgresql_server] Grant datanommer_ro access to datanommer2 db
Merged 2 years ago by zlopez. Opened 2 years ago by zlopez.
fedora-infra/ zlopez/ansible datanommer_ro  into  main

file modified
+7 
@@ -75,6 +75,13 @@ 
 

          owner: "{{ datanommerDBUser }}"
 

          encoding: UTF-8
 

  

+     - name: grant datanommer_ro read only access to datanommer2
 

+       postgresql_privs:
 

+         database: datanommer2
 

+         privs: SELECT
 

+         objs: ALL_IN_SCHEMA
 

+         roles: datanommer_ro
 

+ 

      # Enable timescaledb
 

      - name: enable timescaledb
 

        postgresql_ext:

The datanommer_ro user was created in the task, but never got privilege to read
from datanommer2 db. This commit is fixing that.

Signed-off-by: Michal Konečný mkonecny@redhat.com

Looks good to me. You want to merge and run the playbook or would you like me to? ;)

Let me do it

rebased onto ae6c2b6
2 years ago

Pull-Request has been merged by zlopez
2 years ago

Merged and deployed
Metadata
None
No Tags
Changes Summary 1
+7 -0
file changed
roles/postgresql_server/tasks/datanommer.yml
Powered by Pagure 5.14.1
Documentation • File an Issue • About • SSH Hostkey/Fingerprint
© Red Hat, Inc. and others.