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;

Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Modeler

Software version:

15.0

Operating system(s):

Linux

Software edition:

Advanced

Reference #:

1648034

Modified date:

2013-09-20

Translate my page

Machine Translation

Content navigation