IBM Support

Creating Data Warehouse for JTS using Oracle database results in “java.sql.SQLException: ORA-01031: insufficient privileges” error

Technote (troubleshooting)


Attempts to create Data Warehouse for JTS in IBM Rational Quality Manager 3.0.1 results in the error “java.sql.SQLException: ORA-01031: insufficient privileges”.


The creation of the warehouse on Oracle requires elevated permissions as compared to other databases.

Resolving the problem

When you specify the database user in the connection spec for data warehouse, ensure that the database user has DBA permissions.

This is documented in the Rational Quality Manager 3.0.1 Information Center.

Document information

More support for: Rational Quality Manager
RQM Server

Software version: 3.0.1

Operating system(s): Windows

Reference #: 1507700

Modified date: 03 August 2011

Translate this page: