This content has been marked as final. Show 4 replies
I try to run a procedure with ...authid definer... by another user, which should do an excute immediate with creating a table in the definer schema. Unfortunatly it gives me an "insufficent privilege..." back!?
CREATE OR REPLACE PROCEDURE PRC_EXEC_SQL(p_strSQL LONG) AUTHID DEFINER IS
EXECUTE IMMEDIATE p_strSQL;