Re: configuring oracle database gateway drda
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
-- JeroenReceived on Sat Nov 05 2011 - 16:35:50 CDT