2.4 Doctrine dont use custom schemas

When i can access a database with a user and map other user schema, example:

I connect to the server using USER1 credentials and need to use USER2 schema

Ccctually this is not suported:

Sugestions: 

set a new config parameter with owner to put on front query  like  select * from OWNER.TABLE

and on the mapping update query mappings with these:

swap this:

doctrine\dbal\lib\Doctrine\DBAL\Platforms\OraclePlatform.php
public function getListSequencesSQL($database)
  322      {
  323:         return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ".
  324                 "WHERE SEQUENCE_OWNER = '".strtoupper($database)."'";
  325      }
  ...
  387      public function getListViewsSQL($database)
  388      {
  389:         return 'SELECT view_name, text FROM sys.user_views';
  390      }


FOR THIS

public function getListSequencesSQL($database,$owner)
    {
        return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ".
               "WHERE SEQUENCE_OWNER = '".$owner."'";
    }


    /**
     * {@inheritDoc}
     */
    public function getListSequencesSQL($database,$owner)
    {
        return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ".
               "WHERE SEQUENCE_OWNER = '".$owner."'";
    }


Worked fine for me on tests.


Tnks