Links may not function; however, this content may be relevant to outdated versions of the product.
Troubleshooting: "ORA-01031 insufficient privileges" when creating a database views in Oracle
Symptom
When creating views during Process Commander installations in Oracle, error ORA-01031 insufficient privileges appears. For example:
Table altered.
Table altered.
Table altered.
CREATE VIEW pwbv4_rule_locking
*
ERROR at line 1: ORA-01031: insufficient privileges
CREATE VIEW pwbv4_rule_summary
*
ERROR at line 1: ORA-01031: insufficient privileges
CREATE VIEW pwbv4_rule_overrides
*
ERROR at line 1: ORA-01031: insufficient privileges
CREATE VIEW pwbv4_circumstance_duplicates
*
ERROR at line 1: ORA-01031: insufficient privileges
CREATE VIEW pcv4_assignment_summary
*
ERROR at line 1: ORA-01031: insufficient privileges
CREATE VIEW pcv4_assignmentwb_summary
*
ERROR at line 1: ORA-01031: insufficient privileges
CREATE VIEW pcv4_work_history
*
ERROR at line 1: ORA-01031: insufficient privileges Procedure created.
Solution
1. Modify the System Privileges to include the Create View privilege for the Process Commander user.
2. Drop and recreate the tables for Process Commander. (Valid for all Oracle 10G installations.)
Previous topic Troubleshooting: "Failed to resave page" with Resave Table feature Next topic Troubleshooting: "Obj-Save is trying to write to a non-existent column"