title: JDBC Change Default Schema
body: <p>I'm trying to connect to a sql server 2005 database via JDBC.  </p>
  
  <p>I get the error:</p>
  
  <blockquote>
    <p>com.microsoft.sqlserver.jdbc.SQLServerException: The SELECT permission
    was denied on the object 'MyTable', database 'MyDatabase', schema
    'dbo'.</p>
  </blockquote>
  
  <p>The schema I use to connect is "MyUser".  How do I connect using MyUser as opposed to dbo?</p>
  
  <p>Thanks!</p>