Granular DBA RIGHTS FOR TP_IMUSER to use Oracle for the task persistence database in a UNIX or Windows deployment

Document ID : KB000025910
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

What are the exact privileges required for the task persistence tables?

 

Solution:

To use Oracle for the task persistence database in a UNIX or Windows deployment.

  1. Create a tablespace called IM_TPSTORE.
  2. Create a user tp_imuser.
  3. Grant tp_imuser rights to IM_TPSTORE.
  4. 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.