IBM Support

Insufficient Privileges error when attempting to use ODM in Modeler

Technote (troubleshooting)


Problem(Abstract)

Has enabled ODM under Modeler Helper applications. Getting HY000(1031)[520][ODBC Oracle Wire Protocol driver] (Oracle)ORA-01031: insufficient privileges ORA-06512 at SYS.DBMS_DATA_MINING_TRANSFORM.

Symptom

Has enabled ODM under Modeler Helper applications. Getting HY000(1031)[520][ODBC Oracle Wire Protocol driver] (Oracle)ORA-01031: insufficient privileges ORA-06512 at SYS.DBMS_DATA_MINING_TRANSFORM.


Cause

Once the Oracle Data Mining packages are installed, then the Oracle user for ODM must be granted the following permissions. In this case the userid is SPSS_USR1.

GRANT create mining model TO SPSS_USR1;
GRANT create procedure TO SPSS_USR1;
GRANT create session TO SPSS_USR1;
GRANT create table TO SPSS_USR1;
GRANT create sequence TO SPSS_USR1;
GRANT create view TO SPSS_USR1;
GRANT create job TO SPSS_USR1;
GRANT create type TO SPSS_USR1;
GRANT create synonym TO SPSS_USR1;

Environment

Linux

Diagnosing the problem

The following message is received when running the export node to the Oracle database with ODM enabled:
Getting HY000(1031)[520][ODBC Oracle Wire Protocol driver] (Oracle)ORA-01031: insufficient privileges ORA-06512 at SYS.DBMS_DATA_MINING_TRANSFORM.

Resolving the problem

Granting the following permissions by the ORACLE DBA allowed ODM to be performed in Modeler.

GRANT create mining model TO SPSS_USR1;
GRANT create procedure TO SPSS_USR1;
GRANT create session TO SPSS_USR1;
GRANT create table TO SPSS_USR1;
GRANT create sequence TO SPSS_USR1;
GRANT create view TO SPSS_USR1;
GRANT create job TO SPSS_USR1;
GRANT create type TO SPSS_USR1;
GRANT create synonym TO SPSS_USR1;

Document information

More support for: SPSS Modeler

Software version: 15.0

Operating system(s): Linux

Software edition: Advanced

Reference #: 1648034

Modified date: 20 September 2013