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

863772 Jun 2, 2011 5:14 AM

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.

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

LPS Jun 2, 2011 6:01 AM (in response to 863772)

Create synonym for Table as well as DB link
Like Show 0 Likes(0)

Actions
2. Re: procedure got ORA-01031:insufficient privileges,when AUTHID CURRENT_USER

863772 Jun 3, 2011 1:24 AM (in response to LPS)

Dear sir,
thank you for reply , but that is not my issue.

K.Y.
Like Show 0 Likes(0)

Actions
3. Re: procedure got ORA-01031:insufficient privileges,when AUTHID CURRENT_USER

610771 Jun 3, 2011 1:51 AM (in response to 863772)

check the permission of the other user

____________________________________________________________
For a quick pocket reference of Oracle - http://PocketORACLE.blogspot.com
Like Show 0 Likes(0)

Actions
4. Re: procedure got ORA-01031:insufficient privileges,when AUTHID CURRENT_USER

William Robertson Jun 3, 2011 5:32 PM (in response to 863772)

Is it possible you simply have <tt>CREATE PUBLIC DATABASE LINK</tt> but not <tt>CREATE DATABASE LINK</tt>?

http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_9013.htm#r1c1-t48
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.