On Nov 15, 2009, at 2:35 PM, Melvyn Sopacua wrote:
> Is it possible for a "Django appointments application" to understand
> and use
> the geographical information from the tables in the geo_regionX
> schema and
> equally important to treat that specific schema as read only, as the
> data is
> kept up-to-date by other means?
First, it's important to be sure we know what you mean by
"application." In Django terminology, an application is a sub-
component of a project; a project corresponds to what many people mean
when they say "web application."
The reason this matters is each Django project connects to PostgreSQL
as a single user, so any role-based authentication will be uniform
across everything inside of that project. If each of the
"applications" you are talking about are a different Django project,
you can have each connect as a different user with different
PostgreSQL permissions.
Assuming that you are able to use role-based permissions, you can set
each user to have its own schema search path, and thus make visible to
each user only the schemas that you want that particular user to see.
Django does not, right now, have the ability to qualify table
references with schemas, so the search path is the only practical
method for using multiple schemas with Django.
--
-- Christophe Pettus
[email protected]
--
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=.
