oracle SQL错误：ORA-01039：对视图的基础对象的权限不足

ki1q1bka 于 2022-12-11 发布在 Oracle

关注(0)|答案(3)|浏览(293)

我正在尝试使用以下查询获取视图的解释计划

explain plan for select * from SCHEMA1.VIEW1;

但我越来越
错误报告-

SQL Error: ORA-01039: insufficient privileges on underlying objects of the view

01039. 00000 -  "insufficient privileges on underlying objects of the view"

*Cause:    Attempting to explain plan on other people's view without
           the necessary privileges on the underlying objects of the view.

*Action:   Get necessary privileges or do not perform the offending operation.

获取SQL授权语句时需要帮助

oracle

来源：https://stackoverflow.com/questions/21884073/sql-error-ora-01039-insufficient-privileges-on-underlying-objects-of-the-view

3条答案

按热度按时间

5n0oy7gb1#

Clearly stated in the Oracle Docs :
Security Model
This package runs with the privileges of the calling user, not the package owner (SYS). The table function DISPLAY_CURSOR requires to have select privileges on the following fixed views: V$SQL_PLAN, V$SESSION and V$SQL_PLAN_STATISTICS_ALL.
Using the DISPLAY_AWR Function requires the user to have SELECT privileges on DBA_HIST_SQL_PLAN, DBA_HIST_SQLTEXT, and V$DATABASE.
Using the DISPLAY_SQLSET Functionrequires the user to have the SELECT privilege on ALL_SQLSET_STATEMENTS and ALL_SQLSET_PLANS.
Using DISPLAY_SQL_PLAN_BASELINE Function the user requires the user to have the SELECT privilege on DBA_SQL_PLAN_BASELINES.
All these privileges are automatically granted as part of the SELECT_CATALOG role.

赞(0）回复(0）举报 2022-12-11

dwthyt8l2#

I think you do not have select right granted on some tables or execute right on some functions that may be used in view's query. Check the query of the view "SCHEMA1"."VIEW1"
My guess is there are some functions that you need to be granted execute right on them.
Another guess ( which is more probable ) is that, some tables used in the view are granted to some role and you have that role. As far as i know, in packages, procedures etc. Oracle needs your user explicitly granted to select on those objects, not through a role. Otherwise you won't be able to execute those packages

赞(0）回复(0）举报 2022-12-11

ntjbwcob3#

确保您对底层表具有UPDATE权限。
https://stackoverflow.com/a/74706625/12884507

赞(0）回复(0）举报 2022-12-11