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

**URL:** <https://forum.liquibase.org/t/how-to-assign-schema1-as-username-to-login-to-database-and-deploy-the-script-in-liquibase/5737>\
**Category:** Liquibase Development\
**Created:** [July 27, 2021, 5:17pm UTC](https://forum.liquibase.org/t/how-to-assign-schema1-as-username-to-login-to-database-and-deploy-the-script-in-liquibase/5737 "2021-07-27T17:17:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kalyandrug](https://avatars.discourse-cdn.com/v4/letter/k/f0a364/32.png) [@kalyandrug](https://forum.liquibase.org/u/kalyandrug)\
**Post date:** [July 27, 2021, 5:17pm UTC](https://forum.liquibase.org/t/how-to-assign-schema1-as-username-to-login-to-database-and-deploy-the-script-in-liquibase/5737/1 "2021-07-27T17:17:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)\
**Post date:** [July 28, 2021, 11:35am UTC](https://forum.liquibase.org/t/how-to-assign-schema1-as-username-to-login-to-database-and-deploy-the-script-in-liquibase/5737/2 "2021-07-28T11:35:17Z")

</div>

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:

```auto
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

```