Re: querying over multiple database links
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 6 Jul 2011 23:45:39 +0000 (UTC)
Message-ID: <pan.2011.07.06.23.45.40_at_gmail.com>
On Wed, 06 Jul 2011 12:48:15 -0700, Krzysztof Cierpisz wrote:
Date: Wed, 6 Jul 2011 23:45:39 +0000 (UTC)
Message-ID: <pan.2011.07.06.23.45.40_at_gmail.com>
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.comReceived on Wed Jul 06 2011 - 18:45:39 CDT