Re: querying over multiple database links
From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Thu, 7 Jul 2011 01:07:03 -0700 (PDT)
Message-ID: <b7c9610f-665c-4c27-b3af-66f252b69adb_at_u28g2000yqf.googlegroups.com>
On Jul 7, 1:45 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 06 Jul 2011 12:48:15 -0700, Krzysztof Cierpisz wrote:
> > Unfortunately I don't know credentials that were used for creating that
> > public link. I can use it and know the username with which it connects
> > but cannot replicate that db link on my local database.
>
> Actually, you can. If you retrieve DDL statement for the link by using
> DBMS_METADATA, you will get "CONNECT TO <user> IDENTIFIED BY VALUES <...>
> statement, which will enable you to re-create the link. Catch is that you
> still need "select any catalog" privilege, in order to do that.
>
> --http://mgogala.byethost5.com
Date: Thu, 7 Jul 2011 01:07:03 -0700 (PDT)
Message-ID: <b7c9610f-665c-4c27-b3af-66f252b69adb_at_u28g2000yqf.googlegroups.com>
On Jul 7, 1:45 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 06 Jul 2011 12:48:15 -0700, Krzysztof Cierpisz wrote:
> > Unfortunately I don't know credentials that were used for creating that
> > public link. I can use it and know the username with which it connects
> > but cannot replicate that db link on my local database.
>
> Actually, you can. If you retrieve DDL statement for the link by using
> DBMS_METADATA, you will get "CONNECT TO <user> IDENTIFIED BY VALUES <...>
> statement, which will enable you to re-create the link. Catch is that you
> still need "select any catalog" privilege, in order to do that.
>
> --http://mgogala.byethost5.com
yes, tried that already, but I don't have that priv.
-- chrisReceived on Thu Jul 07 2011 - 03:07:03 CDT