参考说明:
If the referenced item is indeed declared and you believe that you have privileges to refer to that item, check the privileges; if the privileges were granted only via a role, then this is expected and documented behavior. Stored objects (packages, procedures, functions, triggers, views) run in the security domain of the object owner with no roles enabled except PUBLIC. Again, you will be notified only that the item was not declared
Test steps:
SQL> create user chris identified by pass;
User created.
SQL> grant dba to chris;
Grant succeeded.
SQL> connect chris/pass;
Connected.
SQL> create table test1 (name varchar2(10));
Table created.
--Success here.
SQL> drop table test1;
Table dropped.
SQL> create or replace procedure chris_cr_tbl
2 IS
3 begin
4 execute immediate 'create table test1 (name varchar2(10))';
5 end;
6 /
Procedure created.
SQL> exec chris_cr_tbl;
BEGIN chris_cr_tbl; END;
*
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.