Question

  Asked: Apr 6 2008   3:37 AM GMT
  Asked by: Chc225


how to prevent users from pc to use odbc


ODBC, AS/400 security

Hello, how can we stop a user say from a windows to use odbc to connect to the as400 server. I am looking more for setting up a block on the as400 machine rather than on the pc itself.
thanks

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



Hi !

You can use the exit point to validate users that are authorized to use ODBC. Sample program exist in the IBM information Center under this adress : http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaik/rzaikodbcexitprog.htm

As you will see, it is pretty easy to write variance into this example to fulfill your need's.

Dont forget to register your exit program as mentionned on the doc.

Have fun !

__________________
DanTheMan


Options in Windows depend on your domain configuration, as when you are in Windows Server 2003 and using Group Policy you can manage all the desktops by hiding the ODBC control panel item. Check out this Tecnet article for the steps to perform this task:
HOW TO: Hide Control Panel Tools in Windows Server 2003
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database and AS/400.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register