ORA-00942：表或视图不存在（ColdFusion应用程序） [英] ORA-00942: table or view does not exist (ColdFusion application)

问题描述

我有一个带有Oracle 11g后端的ColdFusion 10应用程序。

I have a ColdFusion 10 application with an Oracle 11g backend.

生产版本很好。最近，我有Oracle DBA从生产中刷新测试数据库。现在，我收到 ORA-00942：表或视图不存在错误。

The Production version works fine. Recently, I had the Oracle DBAs refresh the Test database from Production. Now, I receive the ORA-00942: table or view does not exist error.

当我使用SQL Plus和查询运行良好。我对于现在检查什么感到失落。跟踪将我发送到在SQL Plus中正常运行的查询。我错过了什么？

All the tables are there when I use SQLPlus and the queries run fine. I am at a loss as to what to check now. The trace sends me to the query that is running fine in SQLPlus. What have I missed?

更新 - 2014年10月17日
我不知道它是否有什么区别，但抛出代码的行是第一个这里：

Update - 17 October 2014 I don't know if it makes any difference, but the line throwing the code is the 1st one here:

`<cfquery name="getWebMaster" datasource="xxxxtest">
    select * from users where secureuserid in (select secureuserid from hd_role where  webmaster='Yes')
    and userstatus='Active' and UserLevel='XXX/XXIT'
</cfquery>`

这意味着整个cfquery部分是错误， BTW，我想我已经想出了如何嵌入代码。 Thanx！

That means that the entire cfquery section is the error, or just the 1st line? BTW, I think I've figured out how to imbed code. Thanx!

推荐答案

我只能想到一件事。您用于在测试环境中运行应用程序/脚本的用户，以及特定用户拥有的权限 - 它错过了一些权限，因此即使他们在那里也看不到某些内容。

There is only one thing I can think of. The user that you used to run the application/script in your testing environment, and the permission that particular user has - it missed some privileges, so it can not see certain things even though they are there.

这篇关于ORA-00942：表或视图不存在（ColdFusion应用程序）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！