Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Best way to just create Liquibase tracking tables in a schema?

Robert__HOct 10 2022 — edited Oct 10 2022

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)

Comments
Post Details
Added on Oct 10 2022
4 comments
791 views