AnsweredAssumed Answered

connection settings for oracle user not owning schema

Question asked by cvillegas on Sep 15, 2011
Latest reply on Sep 21, 2015 by fconrady
Hi, we want to deploy activiti in a Oracle database in which the application user that connects to the database is not the owner of the schema. Let's say ACT is the user owner of the Activiti tables and ACTAPP is the user that the engine uses to connect to the database (ACTAPP has all the required permissions to use the Activiti tables, but it cannot create or delete the schema).

In Oracle there are several ways to achieve this:1. create synonyms on ACTAPP for all Activiti tables in ACT, 2. use “alter session set current_schema” and 3. qualify objects with schema name, e.g. "ACT"."ACT_RE_PROCDEF".

We want to know if there's someway to configure Activiti to use options 2 or 3, someway to set the schema name of the Activiti tables.

We're deploying Activiti in JBoss together with other applications, for EJB3 beans, hibernate has a default_schema option which allows to qualify all objects with the schema name, but I don't see a similar option in Activiti configuration, or did I missed it?

Outcomes