Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support for ALTER ROLE xxx SET yyy = zzz; #210

Open
BennettKnapek opened this issue May 16, 2022 · 4 comments · May be fixed by #211 or #305
Open

Support for ALTER ROLE xxx SET yyy = zzz; #210

BennettKnapek opened this issue May 16, 2022 · 4 comments · May be fixed by #211 or #305

Comments

@BennettKnapek
Copy link

Hi there,

There is no resource that allows "ALTER ROLE SET = " for use with extensions. Specifically the extension PGAudit (https://www.pgaudit.org/).

This will allow for quicker configuration of these extensions as well as keep all the configuration of a database in one file system rather than having to run these commands after the initial 'terraform apply'.

Please let me know what you think or if this has already been implemented elsewhere.
@bmedlock-depop bmedlock-depop linked a pull request May 17, 2022 that will close this issue
Open
@vmercierfr
Copy link

vmercierfr commented Jun 10, 2022 •
edited
Loading

Hi,

In our use case, we need to enable log_statement for some users.

It will be valuable to have the possibility to set specific settings like ALTER ROLE [user] SET log_statement TO 'all'

@robinjhector
Copy link

Hi!

We're also in need of this functionality.
It would be great if you could set a default role, eg ALTER ROLE my_user SET role some_other_role

@ALX-TH
Copy link

ALX-TH commented Aug 2, 2022

hi all.
@cyrilgdn you have any plans about this feature request ?

@wilsonjackson wilsonjackson linked a pull request May 12, 2023 that will close this issue
Open
@Anton-Shutik
Copy link

This PR makes it easier to add new user parameters + fixes 0-value issue. Probably that will fix that issue as well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
5 participants
@vmercierfr @Anton-Shutik @ALX-TH @robinjhector @BennettKnapek