postgresql_privs module not setting priviledges on views [bug?]

8 views
Skip to first unread message

Matthew Vernon

unread,
Feb 8, 2016, 7:55:53 AM2/8/16
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
Reply all
Reply to author
Forward
0 new messages