I was able to get this working. Was just thinking about it in the wrong
context. Place working code here for others. Thanks everyone!
- postgresql_user: name=bobby password={{ pg_dd_password }} db=postgres
priv=pg_stat_database:SELECT state=present
On Thursday, March 19, 2015 at 10:41:25 AM UTC-6, Brent Clark wrote:
>
> 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/5dfa86ba-81e8-41a7-b19e-026bf0219728%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
