关于视图错误,急,哪个兄弟帮忙看看

[复制链接]
查看11 | 回复3 | 2007-7-11 14:53:06 | 显示全部楼层 |阅读模式
exception:com.bupticet.courseadmin.exception.CourseAdminBDException: SQL Exception occurring: ORA-01031: insufficient privileges
Message:SQL Exception occurring: ORA-01031: insufficient privileges
Locallized Message:SQL Exception occurring: ORA-01031: insufficient privileges
Stack Trace:com.bupticet.courseadmin.exception.CourseAdminBDException: SQL Exception occurring: ORA-01031: insufficient privileges

at com.bupticet.courseadmin.delegate.CourseAdminBD.getCourse(I)Lcom.bupticet.courseadmin.model.CourseTO;(CourseAdminBD.java:142)

at com.bupticet.courseadmin.helper.CourseHelper.getCourse(Ljava.lang.String

Lcom.bupticet.courseadmin.model.CourseTO;(CourseHelper.java:60)

at jsp_servlet._courseadmin.__coursedetail._jspService(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse

V(__coursedetail.java:169)

at weblogic.servlet.jsp.JspBase.service(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse

V(JspBase.java:33)

at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run()Ljava.lang.Object;(ServletStubImpl.java:996)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.FilterChainImpl

V(ServletStubImpl.java:419)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.FilterChainImpl

V(ServletStubImpl.java:463)

at weblogic.servlet.internal.TailFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain

V(TailFilter.java:28)

at weblogic.servlet.internal.FilterChainImpl.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse

V(FilterChainImpl.java:27)

at com.bupticet.filter.EncodingFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain

V(EncodingFilter.java:50)

at weblogic.servlet.internal.FilterChainImpl.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse

V(FilterChainImpl.java:27)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run()Ljava.lang.Object;(WebAppServletContext.java:6458)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Lweblogic.security.subject.AbstractSubject;Ljava.security.PrivilegedAction

Ljava.lang.Object;(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(Lweblogic.security.acl.internal.AuthenticatedSubject;Lweblogic.security.acl.internal.AuthenticatedSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(SecurityManager.java:118)

at weblogic.servlet.internal.WebAppServletContext.invokeServlet(Lweblogic.servlet.internal.ServletRequestImpl;Lweblogic.servlet.internal.ServletResponseImpl;)V(WebAppServletContext.java:3661)

at weblogic.servlet.internal.ServletRequestImpl.execute(Lweblogic.kernel.ExecuteThread;)V(ServletRequestImpl.java:2630)

at weblogic.kernel.ExecuteThread.execute(Lweblogic.kernel.ExecuteRequest;)V(ExecuteThread.java:219)

at weblogic.kernel.ExecuteThread.run()V(ExecuteThread.java:178)

at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Source)
回复

使用道具 举报

千问 | 2007-7-11 14:53:06 | 显示全部楼层
前两天一直正常,今天更新开发环境的数据库的时候,把原来的用户删掉重新用imp导入,然后分配了权限,就成了这个样子
哪个大哥帮忙看看
谢谢了
回复

使用道具 举报

千问 | 2007-7-11 14:53:06 | 显示全部楼层
问题已解决,某表授权不够
回复

使用道具 举报

千问 | 2007-7-11 14:53:06 | 显示全部楼层
其实只要把SQL及错误信息贴出来大家一看就能知道是什么原因,这么一大堆信息真不好找:
ORA-01031: insufficient privileges
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行