Troubleshooting
Problem
The message "java.sql.SQLException: [IBM][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges" is returned when Oracle 10g or 11g is used as the database for the metadata repository.
Symptom
The message "java.sql.SQLException: [IBM][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges" is returned when Oracle 11g or 10g is used as the database for the metadata repository.
Cause
Insufficient privileges exist to create InfoSphere Business Glossary database procedures and triggers on the Oracle database.
Resolving The Problem
Before you update with the Update Installer, run the following SQL commands on the metadata repository database:
grant create trigger to schema_name;
grant create procedure to schema_name;
grant administer database trigger to schema_name;
grant execute on sys.DBMS_LOB to schema_name ;
where schema_name is the name of the schema. Typically the name of the schema is xmeta.
Related Information
Was this topic helpful?
Document Information
Modified date:
23 June 2018
UID
swg21412099