Postgresql_privs module question

Milky_Milk (Milky Milk) July 8, 2016, 10:29am 1

Hello there.
I can’t find a way to create default privileges in postgresql with Ansible.

For example:

`
ALTER DEFAULT PRIVILEGES FOR ROLE reader IN SCHEMA public GRANT SELECT ON TABLES TO username

Is it possible?

Topic		Views
module postgres_privs unexpected behaviour with default privs Ansible Project ubuntu	0	December 17, 2018
[question] postgresql_privs_module: REVOKE CREATE ON schema public FROM [user] Ansible Project	0	August 4, 2020
postgresql_privs module not setting priviledges on views [bug?] Ansible Project	0	February 8, 2016
postgres_priv module to alter schema public owner possible? Ansible Project	0	April 2, 2015
Postgres - grant role to user Ansible Project	1	June 29, 2015