My Oracle Support Banner

ODI 11g Non-Supervisor User Receives ODI-10083 on Regenerating Scenarios (Doc ID 2433500.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version to [Release 11gR1]
Information in this document applies to any platform.


The following error is received when a non-supervisor user regenerates Scenarios in Oracle Data Integrator (ODI) 11g:

com.sunopsis.core.SecurityAccessException: ODI-10083: You are not authorized to Delete the Object: SNP_SCEN: <NAME>
  at com.sunopsis.dwg.DwgObject.deleteControl(
  at com.sunopsis.dwg.DwgObject.deleteGlobal(
  at com.sunopsis.dwg.DwgObject.deleteGlobal(
  at com.sunopsis.dwg.DwgObject.delete(
  at com.sunopsis.dwg.DwgObject.delete(
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.regenerate(
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.regenerate(
  at com.sunopsis.graphical.dialog.SnpsDialogRegenScen.regenScen(
  at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard.doRegenerate(
  at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard.access$1(
  at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard$2.doAction(
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(
  at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(
  at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard.regenerate(
  at oracle.odi.ui.action.SnpsPopupActionRegenScenHandler.actionPerformed(
  at oracle.odi.ui.SnpsActionControler.handleEvent(
  at oracle.ide.controller.IdeAction.performAction(
  at ...

Note that the user is given generic permission to all objects and methods except **Delete** on **Scenario** object.

Following are the steps to reproduce the behavior:

  1. Use ODI 11g, and have an existing Scenario
  2. Have a non-supervisor user MYUSER, with all privileges granted, except **Delete** on **Scenario**.
  3. Start ODI Studio, and connect as user MYUSER.
  4. Try re-generate the Scenario, and observe the ODI-10083 error message.




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.