ORA-01031: 选择视图时权限不足
it1352
帮助6人
问题说明
当我尝试执行包含来自不同模式的表的视图时，会抛出 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?
正确答案
#1
作为表所有者，您需要向正在运行 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;
这篇好文章是转载于：学新通技术网
