How to assign schema1 as username to login to database and deploy the script in liquibase

Hi ,

I have requirements to do deployments as

schema1_script.sql
schema2_script.sql
schema1_script.sql

Need to execute script above said order . Login to schema and execute required script . How to pass Schema1 and schema1 password in liquibase and execute the scripts same way for schema2 . Please send me with example

Regards ,
Ramesh

I’m not sure I fully understand the question, but it seems you would just run 3 Liquibase updates in a row, changing the credentials with each:

liquibase --changelog-file=schema1_script.sql --url="jdbc..." --username=schema1 
--password=pwd1 update 
liquibase --changelog-file=schema2_script.sql --url="jdbc..." --username=schema2 
--password=pwd2 update 
liquibase --changelog-file=schema1_script.sql --url="jdbc..." --username=schema1 
--password=pwd1 update