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 -~----------~----~----~----~------~----~------~--~---
