Opened 8 years ago

Closed 8 years ago

#5656 closed (fixed)

CREATE TRIGGER privileges also needed for Oracle users

Reported by: jbronn Owned by: ikelly
Component: Documentation Version: master
Severity: Keywords: oracle
Cc: Triage Stage: Unreviewed
Has patch: yes Needs documentation:
Needs tests: Patch needs improvement:
Easy pickings: UI/UX:

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)

databases.diff (786 bytes) - added by jbronn 8 years ago.

Download all attachments as: .zip

Change History (2)

Changed 8 years ago by jbronn

comment:1 Changed 8 years ago by ikelly

  • Resolution set to fixed
  • Status changed from new to closed

(In [6443]) Fixed #5656: Added a note about needing CREATE TRIGGER privileges
to run syncdb under Oracle. Thanks, jbronn.

Note: See TracTickets for help on using tickets.
Back to Top