LinkedIn
Copied!

Table of Contents

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

 
Pega Platform 7.1.1 - 8.3.1 System Architect System Administrator System Administration
Suggest Edit

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.