ORA-01031: 选择视图时权限不足

ORA-01031: insufficient privileges when selecting view(ORA-01031: 选择视图时权限不足)

问题描述

当我尝试执行包含来自不同模式的表的视图时，会抛出 ORA-001031 Insufficient privileges.这些表对创建视图的架构具有执行权限.如果我执行视图的 SQL 语句，它就可以工作.我错过了什么?

When I try to execute a view that includes tables from different schemas an ORA-001031 Insufficient privileges is thrown. These tables have execute permission for the schema where the view was created. If I execute the view's SQL Statement it works. What am I missing?

推荐答案

作为表所有者，您需要向正在运行 SELECT 语句的用户授予对基础表的 SELECT 访问权限.

As the table owner you need to grant SELECT access on the underlying tables to the user you are running the SELECT statement as.

grant SELECT on TABLE_NAME to READ_USERNAME;

这篇关于ORA-01031: 选择视图时权限不足的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！