create or replace procedure test(aa in varchar2)
as
str varchar2(50);
begin
str:='create table test_a as select * from b';
execute immediate str;
end;
/
as
str varchar2(50);
begin
str:='create table test_a as select * from b';
execute immediate str;
end;
/
grant create any table to user_name;
楼上的可以再说的明白一些吗?
你创建用户abc,将它赋予DBA的权限,是没有权限创建表结构的create or replace procedure test(aa in varchar2)
as
str varchar2(50);
begin
str:='create table test_a as select * from b';
execute immediate str;
end;
/
grant create any table to abc;二、执行过程:
connect sys/change_on_install
grant create any table to your_user