ORA-01031: insufficient privileges

[rajkumar...@gmail.com]

When we tried to parse the below query using OCI Driver we are getting
the subject error. Please help us to resolve this.

Query
=====

" SELECT "
+ " TIMESTAMP,"
+ " REMOTE_USER,"
+ " COMMENTS "
+ "FROM "
+ " ACTIVITY_LOG A,"
+ " USERS U "
+ "WHERE "
+ " FEATURE_ID = :FEATURE AND"
+ " A.CLIENT_ID = :CLIENT_ID AND"
+ " A.REMOTE_USER = U.USERNAME AND"
+ " TIMESTAMP BETWEEN TO_DATE(:START_DATE,'mm/dd/yyyy
hh24:mi:ss') AND"
+ " TO_DATE(:END_DATE,'mm/dd/yyyy hh24:mi:ss') AND" + "
U.ID IN "
+ DbBindUtil.getIntArrayClause() + " ORDER BY TIMESTAMP";

Error log:

java.sql.SQLException: ORA-01031: insufficient privileges
at weblogic.db.oci.OciCursor.getCDAException(OciCursor.java:
259)
at weblogic.jdbc.oci.Statement.private_parse(Statement.java:
818)
at
weblogic.jdbc.oci.Connection.prepareStatement(Connection.java:717)
at
weblogic.jdbc.pool.Connection.prepareStatement(Connection.java:393)
at
com.atroad.report12.authorization.RbacAuditTrailReportCommand.getAuditRecords(RbacAuditTrailReportCommand.java:
311)
at
com.atroad.report12.authorization.RbacAuditTrailReportCommand.execute(RbacAuditTrailReportCommand.java:
249)
at
com.atroad.report12.ArReportServlet.doPost(ArReportServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
853)
at
weblogic.servlet.internal.ServletStubImpl
$ServletInvocationAction.run(ServletStubImpl.java:1104)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:
430)
at
weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:20)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:
27)
at com.atroad.util.UTF8Filter.doFilter(UTF8Filter.java:25)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:
27)
at
com.atroad.util.security.LoginFilter.doFilter(LoginFilter.java:81)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:
27)
at
weblogic.servlet.internal.WebAppServletContext
$ServletInvocationAction.run(WebAppServletContext.java:5770)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:
690)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:
3230)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:
2642)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:
262)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:224)

[joe.we...@gmail.com]

Hi. We need to discover if there's any reason it's not simply a
permissions issue.
What happens if you log in to the same DBMS, using SQL-PLUS and the
same user/password, and try the same query?
Joe Weinstein at BEA Systems