Specify schema for doing liquibase diff in Oracle?
<p>I'm trying to do a liquibase diff in Oracle using an ant script.</p>

<p>Here's the snippet that preforms the diff</p>

<pre><code>&lt;target name="diff-database"&gt;
    &lt;diffDatabaseToChangeLog
        driver=${db.driver}"
        url="${db.url}"
        username="${db.username}"
        password="${db.password}"

        referenceUrl="jdbc:oracle:thin@hostname:port:sid"
        referenceUsername="user1"
        referencePassword="password1"

        outputFile="changelog.xml"
        classpathref="tools.class.path"
    &lt;/diffDatabaseToChangeLog&gt;
&lt;/target&gt;
</code></pre>

<p>Here's the issue.  </p>

<ul>
<li>The two databases I need to compare are both Oracle.  </li>
<li>For the referenceDB I need access to the tables under a certain user, call it user2, but login for user2 is disabled on the server I need to run this from.</li>
<li>Luckily I have access to the referenceDB under another user, call it user1, and that user has the privilege "SELECT ANY TABLE".  So I should be able to access the tables for user2 with user1.</li>
</ul>

<p>So given all of that information, how do I specify that I want to use user2's tables as the reference DB?</p>

<p>I've look at <a href="http://www.liquibase.org/documentation/ant/index.html" rel="nofollow">this page</a>, but haven't found anything that solves my problem.</p>