Opened 15 years ago

Closed 15 years ago

#5656 closed (fixed)

CREATE TRIGGER privileges also needed for Oracle users

Reported by: jbronn Owned by: Ian 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


The [browser:trunk/docs/databases.txt Oracle Notes] documentation states the following:

"To run python 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 15 years ago.

Download all attachments as: .zip

Change History (2)

Changed 15 years ago by jbronn

Attachment: databases.diff added

comment:1 Changed 15 years ago by Ian Kelly

Resolution: fixed
Status: newclosed

(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