My Oracle Support Banner

ODI Objects Are Locked by Users with View Only Privileges (Doc ID 2832993.1)

Last updated on FEBRUARY 07, 2023

Applies to:

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


Some Oracle Data Integrator (ODI) 12c users may only have a read-only type profile, and as such are only able to view objects and not modify them.

However, ODI objects such as mappings are locked for editing if a user with view-only privilege opens such object.

To reproduce:

  1. Assign a view-only profile to a user
  2. Login as the user and open an ODI object
  3. Login as a user with update privileges, and notice the "lock" on the object


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.