Question

创建存储过程 老师出现 ORA-01031: 权限不足

这是我创建的新用户“gong”
创建存储过程：
create or replace procedure U_SER(
R_name in varchar2;
R_card in varchar2;
R_adress in char;
R_phone in varchar2;
R_opentime in date;
R_openadress in varchar2;
R_openmoney in varchar2) is
begin
insert into gong.USER01(U_NAME,U_card,U_ADRESS,U_PHONE,U_OPENTIME,U_OPENADRESS,U_OPENMONEY)
values(R_name,R_name,R_adress,R_phone,R_opentime,R_openadress,R_openmoney);
end U_SER;

ORA-01031: 权限不足
最后我又在系统用户下去“system”去创建：
SQL> create or replace procedure U_SER(
2 R_name in varchar2;
3 R_card in varchar2;
4 R_adress in char;
5 R_phone in varchar2;
6 R_opentime in date;
7 R_openadress in varchar2;
8 R_openmoney in varchar2) is
9 begin
10 insert into gong.USER01(U_NAME,U_card,U_ADRESS,U_PHONE,U_OPENTIME,U_OPENADRESS,U_OPENMONEY)
11 values(R_name,R_name,R_adress,R_phone,R_opentime,R_openadress,R_openmoney);
12 end U_SER;
13 /

Warning: Procedure created with compilation errors

怎么破？

Answer 1

你这个表USER01在system用户下存在吗？

不存在的话是要报错的

 

用system用户给你的gong用户赋权

grant connect,resource,dba to gong;

这样应该基本就差不多了

Answer 2

给你的gong角色没有授权