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 [email protected].
To post to this group, send email to [email protected].
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.
