I'm running 1.0.2 unfortunately. I'll run the idea of synonyms by our DBAs.
Thanks! Jason On Apr 30, 11:53 am, Ian Kelly <ian.g.ke...@gmail.com> wrote: > On Apr 30, 12:30 pm, Jason Geiger <jgei...@nother.net> wrote: > > > Hello. I'm using Oracle and I would like to have a restricted user for > > Django that can only do DML. Is there a way to specify a schema that > > would prefix all "naked" table references so that this user can find > > the tables as it isn't the schema owner? > > > If there isn't something like that, I think an alter session should do > > the trick: > > alter session set current_schema=my_schema > > But I'm not sure where I should put something like that. > > > Thanks, > > Jason > > Jason, > > If you're using Django trunk or the 1.1 beta version, you can use the > connection_created signal to run your alter session statement at > connection time. > > Otherwise, you could do what we do: create synonyms for the tables > inside the Django user's schema. > > Regards, > Ian --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
