My Oracle Support Banner

Object Instances Granted to Non Supervisor Users are Ignored when Importing ODI 12c Master Repository (Doc ID 2672426.1)

Last updated on APRIL 09, 2021

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


Object instances assigned to a non-supervisor user are not imported when importing an Oracle Data Integrator (ODI) 12c Master Repository.

Note that these privileges are present in the Master Repository export files, but are not imported.

Expected behavior: All user security privileges should be preserved by the export / import operation.

Steps to replicate the behavior:

  1. Have a Master and Work Repositories.
  2. In the ODI Studio > Security UI, create a non-supervisor user.
  3. Grant the following profiles to this user:

  4. In the ODI Studio > Security Manager UI, assign some object instances to this user: Projects, Models, Variables, etc.
  5. Export the Master Repository.
  6. Create a new ODI environment (Master and Work Repositories) using RCU.
  7. Start ODI Studio, and connect to the newly created environment.

    Delete the existing Contexts to avoid conflicts during the import operation.
  8. Import the Master Repository exported at step #5 above.

    Chose synonym Mode INSERT_UPDATE
  9. Upon completion of the import, in the Security Manager UI, observe that the non-supervisor user has been imported, with the granted Profiles, but is missing all the Object Instances granted at step #4.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.