geerlingguy / ansible-role-postgresql

Ansible Role - PostgreSQL
https://galaxy.ansible.com/geerlingguy/postgresql/
MIT License
572 stars 389 forks source link

Documentation for priv attribute of postgresql_users parameter #240

Closed camwardy closed 1 year ago

camwardy commented 1 year ago

Documentation says priv: # defaults to not set. Are there any examples on how this attribute should be populated?

aozmen121 commented 1 year ago

@geerlingguy, @mikedep333 or @C0rn3j We've come across an issue where using the following syntax to grant db user privileges:

priv: db_schema_name.table_name:SELECT

however, we get a generic error which doesn't mean anything. Would you mind checking if our privilege syntax is correct?

Would you mind providing examples as well? there doesn't seems to be any documentation around this.

stale[bot] commented 1 year ago

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!

Please read this blog post to see the reasons why I mark issues as stale.

github-actions[bot] commented 1 year ago

This issue has been closed due to inactivity. If you feel this is in error, please reopen the issue or file a new issue with the relevant details.