分类:
2008-10-15 16:27:55
SQL> select * from dba_role_privs where grantee='TEST'; GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE ------------ ------------ ------------ ------------ TEST DBA NO YES --用户拥有DBA这个role --再创建一个过程: create or replace procedure p_create_table is begin Execute Immediate 'create table create_table(id int)'; end p_create_table; --然后 SQL> exec p_create_table; begin p_create_table; end; ORA-01031: 权限不足 ORA-06512: 在"TEST.P_CREATE_TABLE", line 3 ORA-06512: 在line 1