What privileges an Oracle schema owner should have before configuring BRMS/BPMS to use Oracle database?

Solution Unverified - Updated -

Environment

  • Red Hat JBoss BRMS (BPMS)
    • 5.3.x
    • 6.x
  • Oracle Database
    • 11g R2

Issue

  • What privileges an Oracle schema owner should have before configuring BRMS/BPMS to use Oracle database?
  • Are there any recommendation on providing specific privileges to Oracle schema owner for Production installation of BRMS/BPMS?
  • I am seeing "ORA-01031: insufficient privileges" when starting EAP.

Resolution

  • For Oracle database we recommend to grant at least following privileges, which is equivalent to Connect and Resource role, to a user configured for BRMS/BPMS(which inculdes jBPM5) which should generate all DB artifacts needed by BRMS/BPMS and jBPM5 in a test/stage environment.
    • CREATE SESSION
    • CREATE CLUSTER
    • CREATE INDEXTYPE
    • CREATE OPERATOR
    • CREATE PROCEDURE
    • CREATE SEQUENCE
    • CREATE TABLE
    • CREATE TRIGGER
    • CREATE TYPE
  • If you create a user using Enterprise Manager, CONNECT role will be granted to a user automatically. But please make sure to grant following privileges which is equivalent to Connect role.
    • CREATE SESSION
  • If roll up patch contains 'Alter' table/Sequence operation, please add appropriate permission for it

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.