Re: configuring oracle database gateway drda

From: TheBoss <TheBoss_at_invalid.nl>
Date: 05 Nov 2011 21:35:50 GMT
Message-ID: <Xns9F94E5E26E0ATheBossUsenet_at_194.109.133.133>



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

> On Fri, 04 Nov 2011 13:30:09 -0700, mar.houweninge_at_wxs.nl wrote:
>

>>  have problems with configuring oracle database gateway for drda
>> One of the steps in this process is (according to the manuel) is:
>> 
>> -     GRANT EXECUTE ON PACKAGE oraclegtw.* TO PUBLIC

>
> The Oracle syntax is: GRANT EXECUTE ON oraclegtw TO PUBLIC;

The grant is not performed on Oracle but on DB2.

> Serge Rielau maybe able to help with the DB2 side./

The OP should mention platform (LUW, z/OS, AS400) and version of DB2 first, as syntax for the GRANT differs. As an example, here is the syntax for v9 on z/OS:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=% 2Fcom.ibm.db2z9.doc.sqlref%2Fsrc%2Ftpc%
2Fdb2z_sql_grantpackageprivileges.htm

And the syntax for v9.5 for LUW:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=% 2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0007699.html

As an alternative to executing the grant remotely via the Oracle Gateway interface, the OP could ask his DB2 DBA to execute it directly on the DB2 side.

> /BTW, who's Manuel?
>

He's from Barcelona!

http://en.wikipedia.org/wiki/Manuel_%28Fawlty_Towers%29

http://www.youtube.com/watch?v=pOEbCQIfndc

HTH

-- 
Jeroen
Received on Sat Nov 05 2011 - 16:35:50 CDT

Original text of this message