#6405: Patch - oracle and database owner
---------------------------+------------------------------------------------
Reporter: djogopatrao | Owner: phishy
Type: Bug | Status: new
Priority: Very Low | Milestone: 1.2.x.x
Component: Oracle | Version: 1.2 Final
Severity: Trivial | Keywords:
Php_version: n/a | Cake_version:
---------------------------+------------------------------------------------
When you try to connect to an oracle database using an user other than the
database owner, dbo_oracle.php is able to get the table and column lists,
however queries must specify the owner of this database. For instance,
SELECT * FROM BLABLA
won't work, but
SELECT * FROM OWNER.BLABLA
would.
To solve that, add a 'owner' parameter to the database configuration and
apply the following patch to dbo_oracle.php.
NOTE: I thought that maybe, instead of creating a new parameter 'owner', I
would use the (unused?) 'host' parameter, but it wouldn't make any sense.
909,912d908
< // if owner is specified in the configuration, add it to
the table name
< if ( @$this->config['owner'] )
< $table = "{$this->config['owner']}.$table";
<
--
Ticket URL: <https://trac.cakephp.org/ticket/6405>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to tickets-cakephp@googlegroups.com
To unsubscribe from this group, send email to
tickets-cakephp+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
