Add the possibility to set configuration parameters at the user level.

[Rude-Monkey]

Hi! My team and I have been trying to figure out how we could set configuration parameters for specific roles and/or users using pgbedrock.

Given the documentation, and the code base, our take is that it is only possible to have pgbedrock run ALTER ROLE "{}" WITH "{}"; statements, not ALTER ROLE "{}" SET "{}"; ones.

Would the possibility to do this make sense or is there a better way to do this that doesn't involve manually connecting to our PG instances and manually configuring our users?

Need:

• the possibility to set configuration parameters for roles and/or users.

Example use-case:

Setting different statement_timeout values for different users using pgbedrock.