In Oracle:
A local or central Data Integrator Repository requires that you
Create a dedicated database and define a user with the right to:
Role
Connect
System
Create Sequence
Create Session
Create Table
Create View
Use the DI_Job_Server role which contains these rights.
Quota
Local_Rep Unlimited
Temp Unlimited

Under quota give them unlimited space to the tablespaces they will use always give them unlimited to the temp tablespace
Grant the user the connect and resource roles.