SET ROLE for running migrations

General Discussion
1

Hi, apologies if this has been asked before or if I missed this in the docs - I’m using postgres and I would like to have my migrations run not as the user liquibase is connecting to the DB as, but as a member of a group the liquibase user is part of. This can be accomplished by running SET ROLE [groupname] before executing migrations, so I can get the benefits of preconfigured default permissions on DB objects. Is there a hook that I can use to execute this or otherwise set the execution role?

2

Luke-

I am also interested if such functionality is possible. I was able to accomplish this using formatted sql changelogs and simply wrapping each applicable change statement:

–changeset <<changeset_id>>
SET ROLE;
<<changeset_statement>>
RESET ROLE;

but I don’t know if there is a way to accomplish this with the XML, YAML, or JSON change log options.

Anybody have thoughts on this?