Re: configuring oracle database gateway drda

From: TheBoss <TheBoss_at_invalid.nl>
Date: 06 Nov 2011 22:43:14 GMT
Message-ID: <Xns9F95F14C7F5BATheBossUsenet_at_194.109.133.133>

Mladen Gogala <gogala.mladen_at_gmail.com> wrote in news:pan.2011.11.05.21.37.59_at_gmail.com:

> On Sat, 05 Nov 2011 21:35:50 +0000, TheBoss wrote:
>

>>> The Oracle syntax is: GRANT EXECUTE ON oraclegtw TO PUBLIC;
>> 
>> The grant is not performed on Oracle but on DB2.

>
> If so, why is the question on the Oracle group?
>

Well, I'm not the one posing the question, but I think because the gateway software is an Oracle product and the OP didn't realise that part of the products configuration (more specifically: binding and authorising packages and plans that the gateway uses to access DB2) is performed on DB2. In the mean time the OP has (may be because of my previous answer) posted the question in the DB2 group, with the additional info that (like I suspected) he is configuring for DB2 for LUW, which doesn't allow a generic grant on all packages for a certain schema (via <schema>.*), where DB2 for z/OS does allow such a generic grant.
This also means the doco for the gateway is incorrect/incomplete. The OP needs to find out what packages are used in the oracletgw schema. As this info is not available in the doco, his best bet would be to query the DB2 catalog for this.

Cheers!

-- 
Jeroen

Received on Sun Nov 06 2011 - 16:43:14 CST