ORA-01031:选择视图时特权不足 [英] ORA-01031: insufficient privileges when selecting view

问题描述

当我尝试执行包含来自不同架构的表的视图时，会抛出ORA-001031特权不足.这些表对创建视图的架构具有执行权限.如果执行视图的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:选择视图时特权不足的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！