On 1/27/21 11:56 AM, zausel z wrote: > Hi, > > Error: > > /ansible_postgresql_user_payload.zip/ansible/modules/database/postgresql/postgresql_user.py\", > line 555, in > grant_table_privileges\n File > \"/usr/lib64/python2.7/site-packages/psycopg2/extras.py\", line 120, in > execute\n > return super(DictCursor, self).execute(query, > vars)\npsycopg2.ProgrammingError: relation \"ALL\" does not exist\n\n", > "module_stdout": "", "msg": "MODULE FAILURE\nSee stdout/stderr for the exact > error", "rc": 1} > >
Please try to wrap it in parentheses:
priv: "CONNECT/ALL:SELECT"
Regards
Racke
> [email protected] schrieb am Mittwoch, 27. Januar 2021 um 09:17:19 UTC+1:
>
> What does "not working" mean?
>
> On Wed, 27 Jan 2021 at 08:46, zausel z <[email protected]> wrote:
>
> Hi, I'm using the postgresql_user_module. How can I create a
> read-only-user (SELECT) for all tables of a
> database? priv: CONNECT/ALL:SELECT is not working
>
> thank you
>
> --
> 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 view this discussion on the web visit
>
> https://groups.google.com/d/msgid/ansible-project/b24eb1c8-6cf3-40f4-8548-58fee839ee3an%40googlegroups.com
>
> <https://groups.google.com/d/msgid/ansible-project/b24eb1c8-6cf3-40f4-8548-58fee839ee3an%40googlegroups.com?utm_medium=email&utm_source=footer>.
>
> --
> Sent from a mobile device - please excuse the brevity, spelling and
> punctuation.
>
> --
> 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]
> <mailto:[email protected]>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/c009d142-9c96-4230-b150-b1aaf134e28an%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/c009d142-9c96-4230-b150-b1aaf134e28an%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/40c89004-50cb-cc8e-fb70-0b994919804c%40linuxia.de.
OpenPGP_signature
Description: OpenPGP digital signature
