title: Specify schema for doing liquibase diff in Oracle?
body: <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>