Grant Privileges to User/Role on PostgreSQL Database — Ansible module postgresql_privs

How to automate the granting of all permission for “myuser” user/role on database “testdb” on PostgreSQL using Ansible Playbook and postgresql_privs module.

How to Grant Privileges to User/Role on PostgreSQL Database with Ansible?

I’m going to show you a live demo with some simple Ansible code.

I’m Luca Berton and welcome to today's episode of Ansible Pilot

Ansible Grant Privileges to User/Role on PostgreSQL Database

• community.postgresql.postgresql_privs
• Grant or revoke privileges on PostgreSQL database objects

Let’s talk about the Ansible module `postgresql_privs`.

The full name is `community.postgresql.postgresql_privs`, which means that is part of the collection of modules “community.postgresql” maintained by the Ansible Community to interact with PostgreSQL.

The collection is tested with `ansible-core` version 2.11+, prior versions such as 2.9 or…