Hi,
my scenario:
I want to deploy into target schemas using a dedicated deployment user with proxy access on the deployment target schemas.
However I don't want to create Liquibase tracking tables in every target schema but only in the user schema of the deployment user.
When logged in as proxy there is no permission to create objects in the deployment user but only select, update, insert, delete on existing tracking tables.
So the tracking tables need to be created in advance using the deployment user.
I also want the tracking tables to be created completely empty.
Question:
how to best create just the tracking tables in deployment user schema?
Objects I would like to create in deployment user schema:
DATABASECHANGELOG (table)
DATABASECHANGELOGLOCK (table)
DATABASECHANGELOG_ACTIONS (table)
DATABASECHANGELOG_DETAILS (view)