Re: Differences in 11.2.0.4 & 19.10 when accessing tables across a DBLink

Thanks John. We are late to the 12c+ game and have much to learn.

Doug

> On March 24, 2022 at 11:53 AM John Ridgway <john_at_marjohn.com> wrote:
>
> In 12c there was the addition of the INHERIT REMOTE PRIVILEGES privilege. That might play into this somehow.
>
> John
>
> On Thu, 24 Mar 2022 11:28:52 -0700 (MST), DOUG KUSHNER <dougk5_at_cox.net> wrote:
>
>
> We are testing scenarios in preparation for migrating a few interconnected databases from 11.2.0.4 to 19.10.
>
> One database has a package that performs a query (join) against two small tables in another database through a DBLink. The user that the DBLink connects to has select on these tables granted to it. Everything works when both databases are 11g. When the remote database is 19c, the package cannot access the tables, although running the same query in SQL across the DBLink is successful. BTW, none of the required privileges are granted through roles.
>
> The error is ORA-00942: table or view does not exist
>
> I found a workaround, which is creating private synonyms for the remote tables and changing the PL/SQL to access the synonym name rather than table_name_at_remote_db. Would still like to understand what changed in 19c to cause this issue. Has anyone here encountered this or similar issues with 19c?
>
> TIA,
> Doug
>
>
>

--
http://www.freelists.org/webpage/oracle-l