The information in this article applies to:
Product: Metastorm BPM
Version: 7.x
Issue
A procedure fails to publish and the following error is generated:
Error - ORA-01031: insufficient privileges
ORA-06512: at "METASTORM.EWORK", line 72
ORA-06512: at "METASTORM.ESP\_ADD\_SUFFIX\_GENERATOR", line 6
Resolution
Verify that the database user that's used to publish the procedure has the appropriate privileges.
Metastorm BPM version 7.0:
Roles: CONNECT (default), RESOURCE, and SELECT\_CATALOGUE\_ROLE
System privileges: CREATE SEQUENCE
Metastorm BPM versions 7.5, 7.6
Roles: CONNECT (default), RESOURCE System privileges: CREATE SEQUENCE, CREATE VIEW
See the section entitled Creating an Oracle User for Metastorm BPM Access in the Metastorm BPM Installation Guide for more information.
