ORA-06512 存储过程中创建表权限不足

SQL> create or replace procedure P_test_err is

  2  begin
  3    execute immediate 'create table t(id number)';
  4  end;
  5  /
Procedure created.

SQL> call p_test_err();
call p_test_err()
     *
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "TEST.P_TEST_ERR", line 3

SQL> grant create any table to test;
Grant succeeded.

SQL> call p_test_err();
Call completed.

SQL> select * from t;
no rows selected