存储过程中使用EXECUTE IMMEDIATE提示权限不足，可是单独执行sql没有问题！

[骨骨]

存储过程中使用EXECUTE IMMEDIATE提示权限不足，可是单独执行sql没有问题！

v_sql :=
' create table '
|| i_table
|| ' TABLESPACE '
|| i_table_ts
|| ' PARTITION BY RANGE (REGION_ID) '
|| ' ( '
|| ' PARTITION A VALUES LESS THAN (''B''), '
|| ' PARTITION B VALUES LESS THAN (''C''), '
|| ' PARTITION C VALUES LESS THAN (''D''), '
|| ' PARTITION D VALUES LESS THAN (''E''), '
|| ' PARTITION E VALUES LESS THAN (''F''), '
|| ' PARTITION F VALUES LESS THAN (''G''), '
|| ' PARTITION G VALUES LESS THAN (''H''), '
|| ' PARTITION H VALUES LESS THAN (''I''), '
|| ' PARTITION I VALUES LESS THAN (''J''), '
|| ' PARTITION J VALUES LESS THAN (''K''), '
|| ' PARTITION K VALUES LESS THAN (''L''), '
|| ' PARTITION L VALUES LESS THAN (''M''), '
|| ' PARTITION M VALUES LESS THAN (maxvalue) '
|| ' ) '
|| ' as select * from '
|| i_table_last
|| ' where 1=2 ';

EXECUTE IMMEDIATE v_sql;

请问这是为什么？

[zhaokeke2004]

是权限问题，执行此存储过程的用户一定要有create any table的权限,就是DBA也不行.以前试过了

[GerryYang]

看看现有的权限中是否有create any table权限.

[phant0m]

用dba登录 赋予该用户create any table 权限

[zhpsam109]

不清楚是否有 EXECUTE IMMEDIATE 是否允许用户执行的权限？