Add the possibility to set configuration parameters at the user level.
Opened this issue · 0 comments
Rude-Monkey commented
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.