-- EXECUTE IMMEDIATE 在存储过程中 权限不足的修改方法
grant
CREATE SESSION,
CREATE ANY TABLE,
CREATE ANY VIEW ,
CREATE ANY INDEX,
CREATE ANY PROCEDURE,
ALTER ANY TABLE,
ALTER ANY PROCEDURE,
DROP ANY TABLE,
DROP ANY VIEW,
DROP ANY INDEX,
DROP ANY PROCEDURE,
SELECT ANY TABLE,
INSERT ANY TABLE,
UPDATE ANY TABLE,
DELETE ANY TABLE
to afterupdate;