Re: Database Security with ODBC users...

} Subject: Database Security with ODBC users... } Date: 4 Jan 1995 12:16:49 -0800 } Reply-To: cpilot@teleport.com (Richard Shannon) } Organization: Teleport - Portland's Public Access (503) 220-1016 } } Please help. } } I have an order entry application that has been written with the Fourgen } Case Tools and Informix 5.01 SE on a RS/6000. I would like to use a } third party product for simple ad-hoc reporting like MS Access using } ODBC and INET. Is there a way to protect the database from any } unfortunate updates while using MS Access? I will be using the same } user-id for the order entry application as well as MS Access. } } I posted to the net a month or so ago concerning this with little } response. Is there some better way of doing what I want? Any thoughts } or suggestions would be appreciated. } } Richard Shannon } Willamette Industries, Inc. } (503) 227-5581 } (503) 626-5221 fax One obvious approach is to use different user-ids for order entry and reporting. Must a single user really have both capabilities in the same remote window? Can't you do data entry and reporting in different windows? Granted that I'm not using precisely the same tools that you are; but I have been able to provide restricted update and general reporting to my users by having a "generic" user-id invoked by people doing remote reporting, while update users must connect directly to the server machine (even if only by rlogin) and use their actual user-id for database connect. Regards, Alan +---------------------------+-----------------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Martin Marietta, SLS | Voice: 303-977-9998 | | P.O. Box 179, M/S 3810 | Standard disclaimers apply. Cutesy ones, too. | | Denver, CO 80201-0179 USA | Your mileage may vary. Void where prohibited. | +---------------------------+-----------------------------------------------+