Tweet
Is there anyway to tell what users are accessing files through ODBC? Also, How can I limit user access to a pre-defined selection of files on the AS/400? TIA, Cheryl Collins
-
-
ODBC Security
Cheryl, There are a series of exit points on the system that allow you to prevent access to objects. Assuming that you are on V4R2 1. DSPNETA and check the values DDMACC, PCSACC. These need to be set to *REGFAC 2. WRKREGINF and change the values of QIBM_QZDA_INIT QIBM_QZDA_NDB1 QIBM_QZDA_NDB1 QIBM_QZDA_ROI1 QIBM_QZDA_ROI1 QIBM_QZDA_SQL1 QIBM_QZDA_SQL2 to a program name ( let's say REG001R ) 3. REG001R is a RPGLE Program that receives 2 parameters, One input and one output. C *Entry Plist C Parm RtnCode 1 C Parm Request The Request parameter then needs to be parsed for various things including the user name, file name, type of access etc,. This can then be used to reject ( set RtnCode = '0' ) accesses. Most of this information is ( i think ) available in the manual SC41-3535-01 : Client Access for Windows 95/NT ODBC User's Guide Lots of luck Regards Pillai, Narayanan R Senior Systems Architect American Medical and Life Insurance
Comment