# Changes of two different schemas in same changelog?

**URL:** <https://forum.liquibase.org/t/changes-of-two-different-schemas-in-same-changelog/1319>\
**Category:** General Discussion\
**Created:** [June 24, 2011, 10:13pm UTC](https://forum.liquibase.org/t/changes-of-two-different-schemas-in-same-changelog/1319 "2011-06-24T22:13:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [June 24, 2011, 10:13pm UTC](https://forum.liquibase.org/t/changes-of-two-different-schemas-in-same-changelog/1319/1 "2011-06-24T22:13:00Z")

</div>

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?

&nbsp;

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?

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [June 24, 2011, 10:13pm UTC](https://forum.liquibase.org/t/changes-of-two-different-schemas-in-same-changelog/1319/2 "2011-06-24T22:13:00Z")

</div>

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

&nbsp;

Regards

&nbsp;

JC

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [June 24, 2011, 10:13pm UTC](https://forum.liquibase.org/t/changes-of-two-different-schemas-in-same-changelog/1319/3 "2011-06-24T22:13:00Z")

</div>

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.&nbsp;

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

Nathan