How to redefine liquibase.properties files for different changesets if there are several users (schemas) in the oracle database with privileges only for their schema?

CodePudding user response：

Looking at the release notes for SQLcl 21.4 (current latest version), they state

In this release, you can only capture objects from the schema you are connected to in SQLcl.

So if you are using SQLcl and need to generate changes from multiple schemas, you will need to connect to each schema and generate the changes individually.

CodePudding user response：

When I have such projects as the one you described - with multiple schemas, I prefer to create a special user (schema) with privileges to other schemas and use this user in liquibase.properties file.

Basically, the easiest way is to create a specific role with grants to other schemas.