# databasechangelog table in seperate schema (common for all changes)

**URL:** <https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469>\
**Category:** General Discussion\
**Created:** [October 4, 2013, 12:03am UTC](https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469 "2013-10-04T00:03:00Z")\
**Posts on this page:** 8\
**Page:** 1

<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:** [October 4, 2013, 12:03am UTC](https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469/1 "2013-10-04T00:03:00Z")

</div>

You are able to set the “liquibaseSchemaName” to use to track the databasechangelog tables. If you set the same schema name for across different liquibase runs you can use share the same schema for the liquibase control tables.

How you set the liquibaseSchemaName depends on how you are running liquibase. Are you using command line? Maven? A different way?  
  
Nathan

---

<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:** [October 4, 2013, 12:03am UTC](https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469/2 "2013-10-04T00:03:00Z")

</div>

, **DATABASECHANGELOGLOCK** )

and keep track of the changelog entries for different schema/user in one place…

in simple way…&nbsp;

Is there a way to create changelog tables in one common public schema and kepp track of all changes in those tables

Thanks in advance

---

<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:** [October 4, 2013, 12:03am UTC](https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469/3 "2013-10-04T00:03:00Z")

</div>

Hi Nathan

Thank you for the reply.

I am using Maven plugin.

I tried to use the same attribute and tried to execute ‘update’ command…and it able to create those two tables inside ‘MyLog’ schema… but ton the parallel terms of how we define SchemaName for a changeset… can we define a username,password ?

---

<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:** [October 4, 2013, 12:03am UTC](https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469/4 "2013-10-04T00:03:00Z")

</div>

Unfortunately Liquibase just uses one connection for the changeSet execution and the changelog table creating/insertion at this point.

If you create the databasechangelog tables manually in their schema, do the MySchema1 etc. users have permissions to insert into the liquibase tables?  
  
Nathan

---

<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:** [October 4, 2013, 12:03am UTC](https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469/5 "2013-10-04T00:03:00Z")

</div>

Sorry for late reply.

As you mentioned Liquibase uses one connection for the changeSet execution and changelog table insertion.

Hoping to solve this issue, I created a&nbsp;

---

<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:** [October 4, 2013, 12:03am UTC](https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469/6 "2013-10-04T00:03:00Z")

</div>

That should work. You could try using -_Nathan_

---

<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:** [October 4, 2013, 12:03am UTC](https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469/7 "2013-10-04T00:03:00Z")

</div>

Thanks Nathan for the reply.

It worked when added one more param for catalog name… using…&nbsp;

Thanks again for ur help.

---

<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:** [October 4, 2013, 12:03am UTC](https://forum.liquibase.org/t/databasechangelog-table-in-seperate-schema-common-for-all-changes/2469/8 "2013-10-04T00:03:00Z")

</div>

Good. It should have worked for both parameters on oracle since it doesn’t have a separation between “catalog” and “schema” like some databases.

Nathan&nbsp;