title: Ansible create postgresql user with access to all tables?
body: <p>This should be very simple. I want to make an Ansible statement to create a Postgres user that has connection privileges to a specific database and select/insert/update/delete privileges to all tables within that specific database. I tried the following:</p>
  
  <pre><code>  - name: Create postgres user for my app
      become: yes
      become_user: postgres
      postgresql_user:
        db: "mydatabase"
        name: "myappuser"
        password: "supersecretpassword"
        priv: CONNECT/ALL:SELECT,INSERT,UPDATE,DELETE
  </code></pre>
  
  <p>I get <code>relation \"ALL\" does not exist</code></p>
  
  <p>If I remove <code>ALL:</code>, I get <code>Invalid privs specified for database: INSERT UPDATE SELECT DELETE</code></p>