We have a very specific, security bounded, setup overhere.
A database user is only granted for inserts, selects and updates.
A second database user can do all, but is only activated when deploying a new application
Database used is Oracle
We could setup Liquibase to use the second database user and the rest of the application the first one. Problem with this approach is when the application restart liquibase is unable to verify the changelog and will continue to start the application.
What is the approach to be compliant with the above setup? The ideal situation would be that we can specify 2 credential set to liquibase, 1 to verify the change log and 1 to actually execute the changelog when required.