Opened 17 years ago
Closed 17 years ago
#5656 closed (fixed)
CREATE TRIGGER privileges also needed for Oracle users
| Reported by: | jbronn | Owned by: | Erin Kelly |
|---|---|---|---|
| Component: | Documentation | Version: | dev |
| Severity: | Keywords: | oracle | |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
The [browser:trunk/docs/databases.txt Oracle Notes] documentation states the following:
"To run python manage.py syncdb, you’ll need to create an Oracle database user with CREATE TABLE, CREATE SEQUENCE, and CREATE PROCEDURE privileges."
However, even after adding these privileges to my user I still receive the following error (on 10g):
cx_Oracle.DatabaseError: ORA-01031: insufficient privileges
Looking at the SQL from the sqlall command, I noticed there were database triggers -- after adding the CREATE TRIGGER permission to the user, I was able to execute syncdb. This should be included in the notes -- a patch is attached.
Attachments (1)
Change History (2)
by , 17 years ago
| Attachment: | databases.diff added |
|---|
comment:1 by , 17 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
(In [6443]) Fixed #5656: Added a note about needing CREATE TRIGGER privileges
to run syncdb under Oracle. Thanks, jbronn.