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