Oracle change Schema to a different User

2 posts, 0 answers
  1. Keith Maddocks
    Keith Maddocks avatar
    1 posts
    Member since:
    Dec 2009

    Posted 15 Jan 2010 Link to this post


    I am trying to generate a reverse mapping from an existing database. The user account I have is not the owener of the tables I want to map to. Normally I'd just change my schema so I can access the needed tables, however, the ORM wizard does not show me any tables. Is there a way to accomplish this?

    In SQL I could invoke "ALTER SESSION SET CURRENT_SCHEMA="scott"; ". Can I acheive this with the ORM?

  2. Jan Blessenohl
    Jan Blessenohl avatar
    707 posts

    Posted 15 Jan 2010 Link to this post

    Hello Keith Maddocks,
    You can specify an init sql statement that we execute as first statement on each connection that we open. You can specify it in the backend configuration dilaog or put this inside your backend configuration node:
    <backendconfiguration id="oracleConfiguration" backend="oracle">
      <initSql>ALTER SESSION SET CURRENT_SCHEMA="scott";</initSql>

    All the best,
    Jan Blessenohl
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Back to Top