Matthew Vernon
unread,Feb 8, 2016, 7:55:53 AM2/8/16Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to ansible...@googlegroups.com
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