Hi I have been struggling with this for half a day but could be my lacking knowledge of PostgreSQL. I have a database and I want to gran full privileges on it to a particular user. This is what the psq query for that looks like:
psql -U postgres -c "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO random_user" random_database What would be the equivalent to this using the priv directive in that module? I tried "priv=ALL" but that didn't work and when I try "ALL/ALL:ALL" I get a complaint that relation "ALL" doesn't exist. Does that mean the only way is to list the tables one by one? Regards Navid -- 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/6880f343-3b12-4c5c-841d-ff777fbe488e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
