oracle EXECUTE IMMEDIATE 在存储过程中 权限不足的修改方法

-- 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;