Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

863772Jun 2 2011 — edited Jun 3 2011
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2011
Added on Jun 2 2011
4 comments
304 views