动态DDL执行与Schema Objects显示授权问题

*

　　ERROR at line 1:

　　ORA-01031: insufficient privileges

　　ORA-06512: at "CHRIS.CHRIS_CR_TBL", line 4

　　ORA-06512: at line 1

　　--Failed Here

　　SQL> connect test/oracle

　　Connected.

　　SQL> grant create table to chris;

　　Grant succeeded.

　　--Explicit Grant

　　SQL> connect chris/pass

　　Connected.

　　SQL> exec chris_cr_tbl;

　　PL/SQL procedure successfully completed.

　　SQL> select table_name from all_tables where owner='CHRIS';

　　TABLE_NAME

　　------------------------------

　　TEST1

　　SQL> drop table test1;

　　Table dropped.

文章来源于领测软件测试网 https://www.ltesting.net/