Changes of two different schemas in same changelog?

I have 2 procedures to install in Oracle, procedure1 in schema1 and procedure2 in schema2 of the same database, what is the best practice in this case?

 

Should I install both procedures using same user session I started liquibase with? Or should I login twice, to run SQL with their corresponding users?

if second choice is best? how do you do that in liquibase?

 

Regards

 

JC

It is probably easiest to install both with the same user session you start liquibase with. Liquibase is not able to change users mid-execution so you would need to run a separate liquibase update script which gets more complicated. 


You would need to have a user with sufficient privileges to create procedures in different schemas, though. I dont’ know if that will work for you or not.


Nathan