4 Replies Latest reply: Jun 3, 2011 12:32 PM by William Robertson RSS

    procedure got ORA-01031:insufficient privileges,when AUTHID CURRENT_USER

      Dear Sirs:
      I create a database link when I excute a procedure ,by this statement: "create database link nchu connect to nchu identified by "sys" USING 'nchu' ".
      but the excution got ORA-01031:insufficient privileges,event the procedure when option : AUTHID CURRENT_USER .

      After that , I and "public" to sql statement , and excute the same procedure when the same account logined , it's working .

      Could someone tell me what's rights should I grant to this user ?

      thank you very much.