# Pass a parameter to a SQL Script included with includeAll?

**URL:** <https://forum.liquibase.org/t/pass-a-parameter-to-a-sql-script-included-with-includeall/8356>\
**Category:** General Discussion\
**Created:** [June 20, 2023, 3:32pm UTC](https://forum.liquibase.org/t/pass-a-parameter-to-a-sql-script-included-with-includeall/8356 "2023-06-20T15:32:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hjfitz](https://avatars.discourse-cdn.com/v4/letter/h/ba8739/32.png) [@hjfitz](https://forum.liquibase.org/u/hjfitz)\
**Post date:** [June 20, 2023, 3:32pm UTC](https://forum.liquibase.org/t/pass-a-parameter-to-a-sql-script-included-with-includeall/8356/1 "2023-06-20T15:32:06Z")

</div>

I’ve got a setup that consists of a `master-changelog.xml`, and a number of SQL files under `changelogs/`.

The contents of `master-changelog.xml` looks something like:

```xml
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
	      xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
	      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	      xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
	      xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog https://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.4.xsd
	  http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

	<includeAll 
		path="changelogs/"
		relativeToChangelogFile="true"
	/>

</databaseChangeLog>

```

What I want to be able to do is pass in a sensitive value to one of those SQL files, eg `changelogs/020-create-users.sql`. I’ve tried adding a line, `user.password: some value added at runtime`, but I can’t seem to propagate this to my create-users.sql file. Is this a possibility?

---

<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:** [June 20, 2023, 9:16pm UTC](https://forum.liquibase.org/t/pass-a-parameter-to-a-sql-script-included-with-includeall/8356/2 "2023-06-20T21:16:16Z")

</div>

I have a test-case setup for this.

I have the following in a formatted sql file, in the include all path:

```auto
--liquibase formatted sql

--changeset author:grant_test_employee_privs
GRANT SELECT ON test_employee TO ${schema_id}_read_only;

```

When I execute Liquibase I provide the values for the variables:

```auto
JAVA_OPTS="-Dschema_id=BOB" liquibase ... update

```