We’re starting to use Camunda and our database policies are for application service accounts to use minimal Read/Write credentials. So I’m looking at the management of the Camunda schema to be outside of the application.
Moreover the DBA provides a postgreSQL schema name to work with.
So far I’ve figured out that I have to add the line SET search_path TO <db schema name>; in the sql scripts.
Now I’m looking at Liquibase and wondering if all of those files need to be modified as well.
Has anyone worked with Liquibase in a specific database schema on postgreSQL?