4 Replies Latest reply: Aug 30, 2013 6:05 AM by Billy~Verreynne RSS

    ...Authid Definer

    boffman

      Hi,

       

      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

      BEGIN

       

            EXECUTE IMMEDIATE p_strSQL;

       

      END PRC_EXEC_SQL;

       

       

      cheers,

        Bernhard