Support for ALTER ROLE xxx SET yyy = zzz;

[BennettKnapek]

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.

[vmercierfr]

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]

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]

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

[Anton-Shutik]

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