|
Hi, first, let me apologize in advance if this issue has been brought up on the list before. I haven't been able to find a solution to my problem (googled for it for a couple of hours), though I think it's a pretty easy one and probably someone has stepped into it. This is the story: I have a running Oracle schema, for which I have a readonly user. The tables are owned by user OWNER, but I have user READER to access them. READER has a readonly access to the tables. I have generated the schema classes though DBIx::Class::Schema::Loader (via the Catalyst helper script). I needed the special option "db_schema=OWNER" to correctly generate the classes, since READER owns no tables, but has access to them. The generated classes have correct "...->table('my_table_name')" sentences. But whenever I try to use the schema classes, they don't work and give exceptions about 'table my_table_name does not exist in current schema'. I believe this is due to the table name being specified as 'my_table_name', and not 'OWNER.my_table_name' in the '...->table(' function call, since I have manually modified the class to be like the latter, and it works this way. I'd like to know where can I put the equivalent "db_schema=OWNER" or equivalent option, so that all the schema classes use the tables from the OWNER schema, despite connecting to the database with the READER user. Thanks in advance Best regards Jorge --
|
_______________________________________________ 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]
