Privileges Required to Use ODI Connections

To use the Oracle Data Integrator Connection, you need one of the following:

  • scheduler-administrator or redwood-administrator role.
  • scheduler-user or redwood-login role in combination with the following system-wide, Partition-wide or object-level privileges.

Built-in Roles

  • The scheduler-administrator or redwood-administrator built-in role provides full control over all ODI connections.

Creating and Modifying ODI Connections

You need all of the following privilege ranks to be able to create and modify ODI connections:

  • View - on Partitions GLOBAL and REDWOOD.
  • View - on Applications GLOBAL.Redwood and REDWOOD.DataIntegrator.
  • View - on the Redwood_DataIntegrator extension point.
  • View - on the Redwood_Connections extension point.
  • View - on the existing ODI Process Server and Queue, if applicable.
  • Create - on Process Server and Queue if a new Process Server and Queue are required.
  • Edit - on ODIConnection.

Using the ODI Component

You need all of the following privilege ranks to be able to use an ODI connection:

  • View - on Partitions GLOBAL and REDWOOD.
  • View - on Application REDWOOD.DataIntegrator.
  • View - on the Redwood_ODI extension point.
  • Edit - on ODIConnection. This object is modified when the token gets updated.
  • View - on the Redwood_ODIConnectionConstraint constraint definition.
  • View - on Redwood_ODI library.
  • Submit - on Process Definitions Redwood_DataIntegrator_RunLoadPlan and/or Redwood_DataIntegrator_RunScenario (depending on the functionality you want).
  • View - on the Process Server of the ODI connection.
  • JobAdministrator - on Queue the Queue of the ODI component.

Deleting ODI Connections

  • View - on Partitions GLOBAL and REDWOOD.
  • View - on Applications REDWOOD.ODI and REDWOOD..
  • View - on the Redwood_ODI extension point.
  • View - on the Redwood_Connections extension point.
  • Edit - on ODIConnection.

See Also