My Oracle Support Banner

Unable To Grant Privileges on a Repository to a User Having NG_DESIGNER Assigned, Information: "You must grant this user the non generic privileges" (Doc ID 2141704.1)

Last updated on MAY 23, 2023

Applies to:

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


Attempting to grant privileges on a Repository to an Oracle Data Integrator (ODI) user with NG_DESIGNER profile fails with Information type error:

If a Work Repository is selected to be assigned to a user having NG_DESIGNER profile privileges, the following behavior is observed :

  1. A confirmation window appears: Grant <REPOSITORY_NAME> for the user <USER_NAME>? ==> press OK.
  2. An informational windows appears stating you must grant this user the non generic privileges prior to assigning any instance privilege, although the user has NG_DESIGNER profile assigned.




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.