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.)