Re: [U2] [UD] Disabling/blocking ODBC
I asked Rocket Support about the ODBCLOGIN "feature" availability in UV. They have confirmed that it does not currently exist in UV. There is an enhancement request for it (UNV-13746) to be added. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, 30 January 2013 11:25 PM To: 'U2 Users List' Subject: Re: [U2] [UD] Disabling/blocking ODBC Hi David Thanks - this was probably back on version 10.x when I first heard about the UniData version so it may have been added since. Brian This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Hi David Thanks - this was probably back on version 10.x when I first heard about the UniData version so it may have been added since. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: 30 January 2013 10:41 To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Brian, *UOLOGIN works for me in UV11.1.9 AIX. What arguments are you specifying? I haven't got been able to get *ODBCLOGIN to work. I'm speculating if the arguments the same though - such is the nature of "undocumented" features? Perhaps they should have *APILOGIN to for all API clients? Plus a new @-variable that can identify what server-side interface is handling the call - thus eliminating the need for UOLOGIN and ODBCLOGIN... ? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, 29 January 2013 8:05 PM To: 'U2 Users List' Subject: Re: [U2] [UD] Disabling/blocking ODBC Sadly these appear to be UniData only. Or at least, in the past I've tried with local catalog, global catalog as *UOLOGIN and global catalog as the (illegal) UOLOGIN. None of these got fired. Would be really useful as a central consolidation point for things like setting DATE.FORMAT. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: 28 January 2013 21:23 To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Is this only Unidata or Universe? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, 29 January 2013 9:15 a.m. To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Glad to hear that! Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, January 28, 2013 12:25 PM To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC > There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine > that is called for every ODBC call. You can use this to either blank > prevent ODBC, or setting up restricted login access & login. Dan, I got the info from our VAR and it works great. Thanks! Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Brian, *UOLOGIN works for me in UV11.1.9 AIX. What arguments are you specifying? I haven't got been able to get *ODBCLOGIN to work. I'm speculating if the arguments the same though - such is the nature of "undocumented" features? Perhaps they should have *APILOGIN to for all API clients? Plus a new @-variable that can identify what server-side interface is handling the call - thus eliminating the need for UOLOGIN and ODBCLOGIN... ? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, 29 January 2013 8:05 PM To: 'U2 Users List' Subject: Re: [U2] [UD] Disabling/blocking ODBC Sadly these appear to be UniData only. Or at least, in the past I've tried with local catalog, global catalog as *UOLOGIN and global catalog as the (illegal) UOLOGIN. None of these got fired. Would be really useful as a central consolidation point for things like setting DATE.FORMAT. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: 28 January 2013 21:23 To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Is this only Unidata or Universe? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, 29 January 2013 9:15 a.m. To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Glad to hear that! Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, January 28, 2013 12:25 PM To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC > There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine > that is called for every ODBC call. You can use this to either blank > prevent ODBC, or setting up restricted login access & login. Dan, I got the info from our VAR and it works great. Thanks! Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Sadly these appear to be UniData only. Or at least, in the past I've tried with local catalog, global catalog as *UOLOGIN and global catalog as the (illegal) UOLOGIN. None of these got fired. Would be really useful as a central consolidation point for things like setting DATE.FORMAT. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: 28 January 2013 21:23 To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Is this only Unidata or Universe? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, 29 January 2013 9:15 a.m. To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Glad to hear that! Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, January 28, 2013 12:25 PM To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC > There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine > that is called for every ODBC call. You can use this to either blank > prevent ODBC, or setting up restricted login access & login. Dan, I got the info from our VAR and it works great. Thanks! Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Is this only Unidata or Universe? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, 29 January 2013 9:15 a.m. To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Glad to hear that! Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, January 28, 2013 12:25 PM To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC > There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine > that is called for every ODBC call. You can use this to either blank > prevent ODBC, or setting up restricted login access & login. Dan, I got the info from our VAR and it works great. Thanks! Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Don't forget UOLOGIN. Regards JayJay On 28 Jan 2013, at 19:25, bradley.sch...@usbank.com wrote: >> There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine >> that is called for every ODBC call. You can use this to either blank >> prevent ODBC, or setting up restricted login access & login. > > Dan, I got the info from our VAR and it works great. Thanks! > > Brad. > U.S. BANCORP made the following annotations > - > Electronic Privacy Notice. This e-mail, and any attachments, contains > information that is, or may be, covered by electronic communications privacy > laws, and is also confidential and proprietary in nature. If you are not the > intended recipient, please be advised that you are legally prohibited from > retaining, using, copying, distributing, or otherwise disclosing this > information in any manner. Instead, please reply to the sender that you have > received this communication in error, and then immediately delete it. Thank > you in advance for your cooperation. > > > > - > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Glad to hear that! Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, January 28, 2013 12:25 PM To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC > There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine > that is called for every ODBC call. You can use this to either blank > prevent ODBC, or setting up restricted login access & login. Dan, I got the info from our VAR and it works great. Thanks! Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
> There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine > that is called for every ODBC call. You can use this to either blank > prevent ODBC, or setting up restricted login access & login. Dan, I got the info from our VAR and it works great. Thanks! Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Just as an aside, there's also a UOLOGIN global cataloged routine that is always called before a UO login (I created it with that name). It's a very handy routine to use to manage connections. Bill - Original Message - *From:* aeger...@pobox.com *To:* U2 Users List *Date:* 1/25/2013 11:23 AM *Subject:* Re: [U2] [UD] Disabling/blocking ODBC Dan, Is this also available in Universe? (Release 10.3.7 for windows) (Allen - Sent from my paperweight) On Jan 25, 2013, at 1:49 PM, Daniel McGrath wrote: There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is called for every ODBC call. You can use this to either blank prevent ODBC, or setting up restricted login access & login. If you are under a support contract, contact your support provider and they should be able to help you get ODBCLOGIN up and running. Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software 4600 South Ulster Street · Suite 1100 · Denver, CO 80237 · USA T: +1 720 475 8098 · E: dmcgr...@rocketsoftware.com · W: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Friday, January 25, 2013 11:23 AM To: 'U2 Users List' Subject: [U2] [UD] Disabling/blocking ODBC We may need to figure out a way to disable ODBC access to UniData due to data access concerns. I've set up connections before, but have never approached ODBC from this perspective. I'm hoping there's a service we can turn off or a port we can block. One possible constraint is that we still need to be able to connect to UniData via DataStage. We use the native unidata connector, so I'm hoping that won't get in the way. Thoughts? UniData 7.1 AIX 5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Dan, Is this also available in Universe? (Release 10.3.7 for windows) (Allen - Sent from my paperweight) On Jan 25, 2013, at 1:49 PM, Daniel McGrath wrote: > There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is > called for every ODBC call. You can use this to either blank prevent ODBC, or > setting up restricted login access & login. > > If you are under a support contract, contact your support provider and they > should be able to help you get ODBCLOGIN up and running. > > Cheers, > > Dan McGrath > Managing Director, U2 Servers Lab > Rocket Software > 4600 South Ulster Street · Suite 1100 · Denver, CO 80237 · USA > T: +1 720 475 8098 · E: dmcgr...@rocketsoftware.com · W: u2.rocketsoftware.com > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > bradley.sch...@usbank.com > Sent: Friday, January 25, 2013 11:23 AM > To: 'U2 Users List' > Subject: [U2] [UD] Disabling/blocking ODBC > > We may need to figure out a way to disable ODBC access to UniData due to data > access concerns. I've set up connections before, but have never approached > ODBC from this perspective. I'm hoping there's a service we can turn off or a > port we can block. One possible constraint is that we still need to be able > to connect to UniData via DataStage. We use the native unidata connector, so > I'm hoping that won't get in the way. Thoughts? > > UniData 7.1 > AIX 5.3 > > > TIA, > Brad. > U.S. BANCORP made the following annotations > - > Electronic Privacy Notice. This e-mail, and any attachments, contains > information that is, or may be, covered by electronic communications privacy > laws, and is also confidential and proprietary in nature. If you are not the > intended recipient, please be advised that you are legally prohibited from > retaining, using, copying, distributing, or otherwise disclosing this > information in any manner. Instead, please reply to the sender that you have > received this communication in error, and then immediately delete it. Thank > you in advance for your cooperation. > > > > - > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
(Allen - Sent from my paperweight) On Jan 25, 2013, at 1:49 PM, Daniel McGrath wrote: > There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is > called for every ODBC call. You can use this to either blank prevent ODBC, or > setting up restricted login access & login. > > If you are under a support contract, contact your support provider and they > should be able to help you get ODBCLOGIN up and running. > > Cheers, > > Dan McGrath > Managing Director, U2 Servers Lab > Rocket Software > 4600 South Ulster Street · Suite 1100 · Denver, CO 80237 · USA > T: +1 720 475 8098 · E: dmcgr...@rocketsoftware.com · W: u2.rocketsoftware.com > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > bradley.sch...@usbank.com > Sent: Friday, January 25, 2013 11:23 AM > To: 'U2 Users List' > Subject: [U2] [UD] Disabling/blocking ODBC > > We may need to figure out a way to disable ODBC access to UniData due to data > access concerns. I've set up connections before, but have never approached > ODBC from this perspective. I'm hoping there's a service we can turn off or a > port we can block. One possible constraint is that we still need to be able > to connect to UniData via DataStage. We use the native unidata connector, so > I'm hoping that won't get in the way. Thoughts? > > UniData 7.1 > AIX 5.3 > > > TIA, > Brad. > U.S. BANCORP made the following annotations > - > Electronic Privacy Notice. This e-mail, and any attachments, contains > information that is, or may be, covered by electronic communications privacy > laws, and is also confidential and proprietary in nature. If you are not the > intended recipient, please be advised that you are legally prohibited from > retaining, using, copying, distributing, or otherwise disclosing this > information in any manner. Instead, please reply to the sender that you have > received this communication in error, and then immediately delete it. Thank > you in advance for your cooperation. > > > > - > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
You could take out the path(s) to the Unidata accounts in the UCI file; I don't know if that would affect datastage, but it might be worth checking. > Date: Fri, 25 Jan 2013 11:40:42 -0700 > From: jscha...@gmail.com > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Disabling/blocking ODBC > > I believe both Universe and Unidata run ODBC via the standard UniRPC > port 31438 unless you are running UniRPC on a different port. > > bradley.sch...@usbank.com wrote: > > We may need to figure out a way to disable ODBC access to UniData due to > > data access concerns. I've set up connections before, but have never > > approached ODBC from this perspective. I'm hoping there's a service we can > > turn off or a port we can block. One possible constraint is that we still > > need to be able to connect to UniData via DataStage. We use the native > > unidata connector, so I'm hoping that won't get in the way. Thoughts? > > > > UniData 7.1 > > AIX 5.3 > > > > > > TIA, > > Brad. > > U.S. BANCORP made the following annotations > > - > > Electronic Privacy Notice. This e-mail, and any attachments, contains > > information that is, or may be, covered by electronic communications > > privacy laws, and is also confidential and proprietary in nature. If you > > are not the intended recipient, please be advised that you are legally > > prohibited from retaining, using, copying, distributing, or otherwise > > disclosing this information in any manner. Instead, please reply to the > > sender that you have received this communication in error, and then > > immediately delete it. Thank you in advance for your cooperation. > > > > > > > > - > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > > Jeff Schasny - Denver, Co, USA > jschasny at gmail dot com > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
This sounds very promising. I will pursue this route. Thanks, Dan. > From: Daniel McGrath > To: U2 Users List , > Date: 01/25/2013 12:49 PM > Subject: Re: [U2] [UD] Disabling/blocking ODBC > Sent by: u2-users-boun...@listserver.u2ug.org > > There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine > that is called for every ODBC call. You can use this to either blank > prevent ODBC, or setting up restricted login access & login. > > If you are under a support contract, contact your support provider > and they should be able to help you get ODBCLOGIN up and running. > > Cheers, > > Dan McGrath U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
> You can can kill the unirpc process ? That would do it. Unfortunately, it would also take down UO and UOJ, which we use. Hmmm. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is called for every ODBC call. You can use this to either blank prevent ODBC, or setting up restricted login access & login. If you are under a support contract, contact your support provider and they should be able to help you get ODBCLOGIN up and running. Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software 4600 South Ulster Street · Suite 1100 · Denver, CO 80237 · USA T: +1 720 475 8098 · E: dmcgr...@rocketsoftware.com · W: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Friday, January 25, 2013 11:23 AM To: 'U2 Users List' Subject: [U2] [UD] Disabling/blocking ODBC We may need to figure out a way to disable ODBC access to UniData due to data access concerns. I've set up connections before, but have never approached ODBC from this perspective. I'm hoping there's a service we can turn off or a port we can block. One possible constraint is that we still need to be able to connect to UniData via DataStage. We use the native unidata connector, so I'm hoping that won't get in the way. Thoughts? UniData 7.1 AIX 5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
You can can kill the unirpc process ? -Original Message- From: Jeff Schasny To: U2 Users List Sent: Fri, Jan 25, 2013 10:41 am Subject: Re: [U2] [UD] Disabling/blocking ODBC I believe both Universe and Unidata run ODBC via the standard UniRPC port 31438 unless you are running UniRPC on a different port. bradley.sch...@usbank.com wrote: > We may need to figure out a way to disable ODBC access to UniData due to > data access concerns. I've set up connections before, but have never > approached ODBC from this perspective. I'm hoping there's a service we can > turn off or a port we can block. One possible constraint is that we still > need to be able to connect to UniData via DataStage. We use the native > unidata connector, so I'm hoping that won't get in the way. Thoughts? > > UniData 7.1 > AIX 5.3 > > > TIA, > Brad. > U.S. BANCORP made the following annotations > - > Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. > > > > - > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
I believe both Universe and Unidata run ODBC via the standard UniRPC port 31438 unless you are running UniRPC on a different port. bradley.sch...@usbank.com wrote: We may need to figure out a way to disable ODBC access to UniData due to data access concerns. I've set up connections before, but have never approached ODBC from this perspective. I'm hoping there's a service we can turn off or a port we can block. One possible constraint is that we still need to be able to connect to UniData via DataStage. We use the native unidata connector, so I'm hoping that won't get in the way. Thoughts? UniData 7.1 AIX 5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UD] Disabling/blocking ODBC
We may need to figure out a way to disable ODBC access to UniData due to data access concerns. I've set up connections before, but have never approached ODBC from this perspective. I'm hoping there's a service we can turn off or a port we can block. One possible constraint is that we still need to be able to connect to UniData via DataStage. We use the native unidata connector, so I'm hoping that won't get in the way. Thoughts? UniData 7.1 AIX 5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users