CREATE TRIGGER privileges also needed for Oracle users
|Reported by:||jbronn||Owned by:||ikelly|
|Has patch:||yes||Needs documentation:|
|Needs tests:||Patch needs improvement:|
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.