Skip to main content

This content has been archived and is no longer being updated.

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

Suggest edit Updated on September 10, 2021

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"

Tags

Pega Platform 7.1.1 - 8.3.1 System Architect System/Cloud Ops Administrator System Administration
Did you find this content helpful? YesNo

100% found this useful

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us