ORACLE 存储过程权限问题

最新推荐文章于 2023-08-06 09:17:09 发布

风之子ADAM

最新推荐文章于 2023-08-06 09:17:09 发布

阅读量793

点赞数

分类专栏： ORA-ERR 文章标签： ORACLE 存储过程权限问题 store procedure

本文链接：https://blog.csdn.net/JIANGJIAN12345/article/details/27296591

版权

ORA-ERR 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

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