title: How can I access the data from a table in another schema
body: <p>I have to get data from a table in another schema, which I do have grant permission.</p>
  
  <p>Tried select query from my current database. I am able to acess the table in other schema(<strong>USERAUTH</strong>)</p>
  
  <p>Entity had created with schema attribute </p>
  
  <pre><code>@Entity
  @Table(name="PESRSON",  schema=USERAUTH)
  public class Person implements Serializable {
      private static final long serialVersionUID = 1L;
  
      @Id
      @Column(name="CODE")
      private Long code;
  
      @Column(name="TITLE")
      private String  title;
  
      .....
      .....
      .....
  
  }
  </code></pre>
  
  <p>Created Repository</p>
  
  <pre><code>@Repository
  public interface PersonRepo extends JpaRepository&lt;Person, Long&gt; {
  
  
  }
  </code></pre>
  
  <p>In service, to get the record.</p>
  
  <pre><code>@Autowired
  private PersonRepo personRepo;
  .....
  .....
  .....
  
  Person per = personRepo.getOne(663L);
  </code></pre>
  
  <p>Exception on server start.</p>
  
  <pre><code>ERROR ORA-00942: table or view does not exist
  </code></pre>
  
  <p>How can I access the data from a table in another schema.</p>