ORACLE 存储过程权限问题

ORACLE 创建使用存储过程时，常会遇到权限问题，角色权限不被认同，需要显示授权。如显示grant select any table to tester;之后，下面的测试就OK了

create user tester identified by tester; grant connect ,dba to tester; create user tester2 identified by tester; grant connect,resource to tester2; conn tester2/tester create table t1(aa int); insert into t1 values(1); commit; conn tester/tester select * from tester2.t1; CREATE OR REPLACE PROCEDURE a1 is a int; begin execute immediate 'select * from tester2.t1'; end a1; / show error set serveroutput on exec a1