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 JUNE 08, 2023

Applies to:

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

Symptoms

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:

      CONNECT
      NG DESIGNER
      NG METADATA ADMIN
     
  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.

 

Cause

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

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

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