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

Last updated on JUNE 16, 2022

Applies to:

Symptoms

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(DwgObject.java:1280)
  at com.sunopsis.dwg.DwgObject.deleteGlobal(DwgObject.java:1322)
  at com.sunopsis.dwg.DwgObject.deleteGlobal(DwgObject.java:1347)
  at com.sunopsis.dwg.DwgObject.delete(DwgObject.java:962)
  at com.sunopsis.dwg.DwgObject.delete(DwgObject.java:941)
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.regenerate(SnpGeneratorSQLCIT.java:11709)
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.regenerate(SnpGeneratorSQLCIT.java:11614)
  at oracle.odi.generation.support.ScenarioUtils.regenerateScen(ScenarioUtils.java:282)
  at com.sunopsis.graphical.dialog.SnpsDialogRegenScen.regenScen(SnpsDialogRegenScen.java:106)
  at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard.doRegenerate(DwgScenGeneratingWizard.java:230)
  at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard.access$1(DwgScenGeneratingWizard.java:198)
  at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard$2.doAction(DwgScenGeneratingWizard.java:174)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
  at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)
  at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard.regenerate(DwgScenGeneratingWizard.java:159)
  at oracle.odi.ui.action.SnpsPopupActionRegenScenHandler.actionPerformed(SnpsPopupActionRegenScenHandler.java:38)
  at oracle.odi.ui.SnpsActionControler.handleEvent(SnpsActionControler.java:86)
  at oracle.ide.controller.IdeAction.performAction(IdeAction.java:529)
  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.

Changes

Cause

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