Django

Code

Ticket #5656 (closed: fixed)

Opened 11 months ago

Last modified 11 months ago

CREATE TRIGGER privileges also needed for Oracle users

Reported by: jbronn Assigned to: ikelly
Milestone: Component: Documentation
Version: SVN Keywords: oracle
Cc: Triage Stage: Unreviewed
Has patch: 1 Needs documentation:
Needs tests: Patch needs improvement:

Description

The 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

databases.diff (0.8 kB) - added by jbronn on 10/01/07 20:55:50.

Change History

10/01/07 20:55:50 changed by jbronn

  • attachment databases.diff added.

10/02/07 10:26:39 changed by ikelly

  • status changed from new to closed.
  • resolution set to fixed.

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

Add/Change #5656 (CREATE TRIGGER privileges also needed for Oracle users)




Change Properties
Action