高手请进!存储过程授权问题!
create or replace procedure test as
begin
EXECUTE IMMEDIATE 'truncate table user1.table1';
insert into user1.table1 select * from table;
commit;
end;
SQL> execute test;
ORA-01031: 权限不足
ORA-06512: 在 "user.test", line 3
ORA-06512: 在 line 1
请问:该授予哪些权限?