What are the exact privileges required for the task persistence tables?
To use Oracle for the task persistence database in a UNIX or Windows deployment.
- Create a tablespace called IM_TPSTORE.
- Create a user tp_imuser.
- Grant tp_imuser rights to IM_TPSTORE.
- Give DBA rights to the user.
Clarification on #4 above:
DBA rights are not required; only DB OWNER rights are required for runtime as the tp_imuser only needs to UPDATE, INSERT, SELECT and EXECUTE. However, to run the setup scripts, DBA rights are required.