doctrine/doctrine2 — pull request #1062 by cirovargas (2014-06-17 14:52:11+00:00)
Title: Doctrine new config parameter on oracle dbal/mapping: Owner

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