Im guessing grant privs on views isnt supported with postgresql_user or postgresql_privs?
On Thursday, March 19, 2015 at 6:43:35 AM UTC-6, An Internet Denizen wrote: > > pg_stat_database is a view : > http://www.postgresql.org/docs/9.4/static/monitoring-stats.html#PG-STAT-DATABASE-VIEW > > > > On Wednesday, March 18, 2015 at 9:27:31 PM UTC-5, Brent Clark wrote: >> >> Hello, >> >> I am trying to use the postgresql_user function to create and grant privs >> on the user. Im getting failure messages relating to the priv. >> >> - postgresql_user: name=bobby password={{ pg_dd_password }} >> db=pg_stat_database priv=SELECT state=present >> >> What I want basically to do is the following >> >> create user bobby with password 'some_password'; >> grant SELECT ON pg_stat_database to bobby; >> >> I think my issue is that pg_stat_database isnt really a database or a >> table, but a collection of views, if I am understanding postgresql >> correctly. >> >> Any help is appreciated. >> > -- 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/10856e62-c411-47e2-90b6-8131aefe3ebf%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
