On Thu, Feb 23, 2012 at 5:52 PM, Alexander Hartmaier < [email protected]> wrote:
> Hi Marc, > are all your objects (tables, views, etc.) in the same Oracle schema? > If so you can tell Oracle to search this schema after connecting with > on_connect_do ALTER SESSION SET CURRENT_SCHEMA = $yourschemaname > > The only place where this failed for me was private database links in that > schema. > > > Hi Alexander, no, they are in 2 schemas but the owner of schema1 has read/write access to schema2. Strangely enough, it's no problem for schema1 user to query tables of schema2. However, for update, suddenly the tables need to be explicitely prefixed with the schema2 name. Regards, Marc
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
