On Dec 22, 9:22 am, Vikram <vikramsingh...@gmail.com> wrote: > Scenario: > table v$session contains all the current sessions information and is > under SYS user. My web application should connect as webinfo user that > has read-only access on v$session table, query the data and present it > in webpage. > > Do I write views that directly talk to these tables, pull data and > render it online? Or is there a better way?
Yes, you should create synonyms (or views, if you want more fine- grained control) that pull those tables into the Django user's schema. Inspectdb will not work for synonyms or views in Oracle, so you will need to write the models by hand. Cheers, 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-us...@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.
