On Jun 1, 2:58 pm, Jani Tiainen <[email protected]> wrote: > 1.6.2012 10:43, rahajiyev kirjoitti: > > > > > > > > > > > Hello. The user connecting to Oracle is an ordinary user and needs to > > prefix all tables with the schema name. > > I've tried crafting Meta.db_table like so: > >http://cd-docdb.fnal.gov/cgi-bin/RetrieveFile?docid=3156&version=1&fi... > > > But I get error > > > DatabaseError at / > > > schema "foo" does not exist > > LINE 1: ...ty", "foo"."table_name"."address_country" FROM "foo"."... > > > I also tried wrapping request in a TransactionMiddleware and execute > > this SQL before the fetching (modifying Meta accordingly): > > MyModel.objects.raw('ALTER SESSION SET CURRENT_SCHEMA=foo') > > > Neither way helped. The user has the needed permissions. > > Since Oracle doesn't make a difference between user and schema (they're > equivalents) > > Simplest thing is to create (private/public) synonyms for tables for > user in question. Otherwise you need to prefix with schema name. >
Thank you, I think private synonyms is a nice workaround, since I couldn't get prefixing to work. > See also tickethttps://code.djangoproject.com/ticket/6148 > > -- > Jani Tiainen > > - Well planned is half done and a half done has been sufficient before... -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
