Hi,
I have the following:
- name: grant SELECT privs to roles
sudo: yes
sudo_user: postgres
postgresql_privs: db=raven type=table priv=SELECT objs=ALL_IN_SCHEMA
role={{item}}
with_items:
- ravenstaff
- readonly
This fails to grant SELECT on views in the public schema, whereas:
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;
Does (and the postgres documentation says that it should do).
Is this a bug in the postgresql_privs module?
Thanks,
Matthew
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to ansible-project+unsubscr...@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/56B89032.7050206%40cam.ac.uk.
For more options, visit https://groups.google.com/d/optout.
