OMWB Repository User Privileges (Doc ID 357052.1)

Last updated on AUGUST 07, 2014

Applies to:

Oracle Migration Workbench - Version 10.1.0.4 and later
Information in this document applies to any platform.
Checked for relevance 07-Aug-2014

Symptoms


- This Note is Valid for OMWB Only

OMWB error.log file contains error:
Informix9WorkbenchEventListener.createSynonyms() java.sql.SQLException:
ORA-01031: insufficient privileges

Continuing with the migration will cause errors in the migration like:
Failed to get list of dbsapces and the error.log gets entries like:
EXCEPTION : Informix7SourceModelLoad.updateSysusersForInformixAndRoot()
ORA-00942

 

This error might differ from Plugin to Plugin, but the root cause is the same for all Plugins.


Cause

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 hundreds of Community platforms