puppetlabs / puppetlabs/puppetlabs-postgresql
Grant role with admin option
Open
Nobody has claimed this yet.
- Dominant language
- Ruby
- Stars
- 232
- Forks
- 610
- Avg merge
- 5d 23h
- Merged PRs (30d)
- 4
Description
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start at the postgresql::server::grant_role entry point and trace how role assignments are generated. Add the requested with_admin_option flag, then verify that enabling it produces a PostgreSQL 16-compatible role assignment while preserving existing behavior when it is absent.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, ruby
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 55/100