#6148: Add generic support for database schemas
-------------------------------------+-------------------------------------
Reporter: ikelly | Owner: akaariai
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) | Resolution:
Severity: Normal | Triage Stage: Design
Keywords: oracle postgresql | decision needed
mysql schemas | Needs documentation: 1
Has patch: 1 | Patch needs improvement: 1
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Comment (by ikelly):
Catching up now on this ticket, I'll try to do some testing on Oracle
soon.
I want to suggest that we also consider foreign-schema creation to be out
of scope for databases like Oracle, where schemas and users are the same
things. The current code that attempts to do all this through a single
configured Oracle connection is a bit naive; it assumes that all users
have the same password, and it appears to also assume that the configured
Django user has the CREATE ANY TABLE privilege, which would be an unusual
production setup.
Instead, a Django user who wants to manage multiple Oracle schemas with
Django should set up a separate database connection for each schema. This
way we're not trying to create or alter objects belonging to other users.
For the REFERENCES issue, there are two cases -- either the foreign schema
is not also managed by Django, in which case the user is responsible for
ensuring the necessary grants, or both schemas are managed by Django, in
which case we might better be able to automate the grant with the using()
construct.
--
Ticket URL: <https://code.djangoproject.com/ticket/6148#comment:116>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
