各位老大,我在ORACLE里新建立了一个用户。
语句如下:
CREATE USER appsquery IDENTIFIED BY appsquery
default tablespace APPS_TS_TX_DATA
temporary tablespace TEMP
profile DEFAULT;
grant create session to appsquery;
grant select on apps.pa_projects_all to appsquery;
grant select on apps.pa_project_status_lov_v to appsquery;
grant select on apps.pa_tasks to appsquery;
grant select on apps.pa_budget_versions to appsquery;
grant select on apps.pa_resource_assignments to appsquery;
grant select on apps.pa_budget_lines to appsquery;
grant select on apps.wf_items to appsquery;
grant execute on apps.wf_engine to appsquery; 然后我用这个用户登录,执行如下语句:
SELECT * FROM apps.wf_items w
WHERE apps.wf_engine.getitemattrtext(w.item_type, w.item_key, 'PA_PROJECT_NUMBER') = ‘****’
AND w.item_type = 'PABUDWF';结果提示:
ORA-00942:表或视图不存在
ORA-06512:在APPS.WF_ENGIN,LINE 1663
ORA-06512:在 LINE 1这个包的第1663行是 :
1660 when others then
1661 Wf_Core.Context('Wf_Engine', 'GetItemAttrText', itemtype, itemkey,
1661 aname);
1663 raise;
麻烦问一下应该给这个用户赋什么权限才能执行这个包?
谢谢!
语句如下:
CREATE USER appsquery IDENTIFIED BY appsquery
default tablespace APPS_TS_TX_DATA
temporary tablespace TEMP
profile DEFAULT;
grant create session to appsquery;
grant select on apps.pa_projects_all to appsquery;
grant select on apps.pa_project_status_lov_v to appsquery;
grant select on apps.pa_tasks to appsquery;
grant select on apps.pa_budget_versions to appsquery;
grant select on apps.pa_resource_assignments to appsquery;
grant select on apps.pa_budget_lines to appsquery;
grant select on apps.wf_items to appsquery;
grant execute on apps.wf_engine to appsquery; 然后我用这个用户登录,执行如下语句:
SELECT * FROM apps.wf_items w
WHERE apps.wf_engine.getitemattrtext(w.item_type, w.item_key, 'PA_PROJECT_NUMBER') = ‘****’
AND w.item_type = 'PABUDWF';结果提示:
ORA-00942:表或视图不存在
ORA-06512:在APPS.WF_ENGIN,LINE 1663
ORA-06512:在 LINE 1这个包的第1663行是 :
1660 when others then
1661 Wf_Core.Context('Wf_Engine', 'GetItemAttrText', itemtype, itemkey,
1661 aname);
1663 raise;
麻烦问一下应该给这个用户赋什么权限才能执行这个包?
谢谢!
解决方案 »
- oracle客户端连接服务器端出现问题
- Oracle多表的模糊查询
- 富有挑战性的问题,建立超大数据库的问题.
- oracle自定义table类型不能被fetch?
- case能否写在where 条件内。谢谢
- 這個語句爲什麽報錯 麻煩各位~
- ORALCE9I安装中出现的问题~及LDAP问题
- 如何让时间自增
- 安装8.17在P4 WIN2000上,刚装完是好的,重起后进入SQL/PLUS出现错误
- 使用PL/SQL TOAD,OBJECT Browser调试存储过程时,如何把cursor类型的输入参数赋值。
- OCI有session管理机能么? OCIObjectLockNoWait()方法怎么用啊?
- 求sql语句
还是grant execute wf_engine.<func> to <user>一个个的执行比较好。
执行好后不行,同样的错误。grant execute on apps.wf_engine.SetItemAttrText2 to appsquery;
这个语句不对,提示缺失关键字。
还有什么办法?
grant select on apps.WF_ITEM_ATTRIBUTES to appsquery;
grant select on apps.WF_ITEM_ATTRIBUTE_VALUES to appsquery;
grant select on apps.WF_RESOURCES to appsquery; grant execute on apps.wf_engine to appsquery;
grant execute on apps.wf_core to appsquery;
grant execute on apps.WF_CACHE to appsquery; grant execute on sys.dbms_utility to appsquery;
grant execute any procedure to appsquery;一共赋予了这么多,还是同样的错误。
不知道还有啥。
我也猜想是有表可能权限没给
我甚至都在系统权限里把
grant any privilege
select any table
select any transaction
select any sequence
select any cube
也赋予了这个用户,结果还是报上面的错误,真是奇怪了。