puppetlabs / puppetlabs-postgresql

Puppet module for managing PostgreSQL
Apache License 2.0
228 stars 614 forks source link

Grant role with admin option #1617

Open vaol opened 1 month ago

vaol commented 1 month ago

Use Case

Since PostgreSQL16 it became mandatory to have the admin option on a role assignment to be able to manage the role (eg to change the password)

Describe the Solution You Would Like

A flag with_admin_option in postgresql::server::grant_role

Describe Alternatives You've Considered

We could use an additional postgresql_psql naturally, but it is less convenient.