存储过程、执行命令及错误提示如下:
create or replace procedure zzj
is
begin
execute immediate 'create table temp_1 as select * from temp_ajust';
end zzj;SQL> execute ZZJbegin ZZJ; end;ORA-01031: insufficient privileges
ORA-06512: at "UWEY_CR14.ZZJ", line 4
ORA-06512: at line 1
create or replace procedure zzj
is
begin
execute immediate 'create table temp_1 as select * from temp_ajust';
end zzj;SQL> execute ZZJbegin ZZJ; end;ORA-01031: insufficient privileges
ORA-06512: at "UWEY_CR14.ZZJ", line 4
ORA-06512: at line 1
ORA-06512: at "UWEY_CR14.ZZJ", line 4你又建彪的权限但是没有建立procedure 的权限
grant create table to username;