We’re a fairly large shop, and we use liquibase via maven. As we add more and more schemas, we have to add every single schema user to the settings.xml for each one of the test environments (currently ten of them), which is getting unwieldy. The settings.xml file for our main build user is almost at 4,000 lines.
So I was wondering if anyone has come up with a good way to use a single user to write to many schemas in Oracle, without giving that one user permissions for sys/system tables. Basically, a release user that is not an su.
It looks like we could use the “liquibaseSchemaName” setting to set the changelog table to still be within each schema, but it;s the authentication that I’m unsure about.
Has anyone done this already?