Use the Ansible module postgresql_privs_module to manage user privileges

[jeffwidman]

http://docs.ansible.com/ansible/postgresql_privs_module.html

It'd be more expressive/convenient to use this rather than the postgresql_user module for managing user privileges: https://github.com/ANXS/postgresql/blob/master/tasks/users_privileges.yml#L4

It's an Ansible core module, so should be supported by them.

[egmont1227]

Found some more PR related to this and linked them.

@gclough @robustq

[github-actions]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

[pulse-mind]

There is a deprecation warning:
[DEPRECATION WARNING]: Param 'priv' is deprecated. See the module docs for more information. This feature will be removed from community.postgreql in version 4.0.0. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.

[github-actions]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

[pulse-mind]

to keep it open