Creating Data Warehouse for JTS using Oracle database results in “java.sql.SQLException: ORA-01031: insufficient privileges” error
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.