Re: Issues in Informix

Hi Hari, I'm interested in your model. Could you give me more details??? Thanks Dave Hari Gupta wrote: > I agree with all Informix Gurus, who contributes in this newsgroup, their > openion to implement database security, however, I have partially > implemented (NOT 100%) this by using database roles. There is a lot of work > to be done before impleneting this. Be aware of the limitation of "Set Role > <Rple Name>" > at application level. You can also control public access for any table in > your database and grant required access to database object by using role. I > have used with IDS 9.21 UC3. If you need details about my model, pl. let me > know. > > Hari > > "David Mendez" <dhmendez@mail.cinvestav.mx> wrote in message > news:3EC5CCFE.F30D5055@mail.cinvestav.mx... > > I need to implement some aspects related to security in a database > > Informix: I have no experience in Informix so is more complicated, and I > > have several issues: > > > > ' The default permission were changed to 777 or 755 in some files of the > > following dirs /informix, /informix/bin, /informix/etc, so it's too > > risky.I need the default installation permissions. Where can I get a > > list of them???? > > > > ' Is it possible to create a Script in order to verify informix tables > > and databases permissions??? > > > > ' And I finally I need to restrict access application through ODBC's to > > a DB. For example I do not want to allow connections from excel or lotus > > to my DB, I only want to allow connections from one specific > > application. Is it this possible??? Is there any solution for this > > purpose??? > > > > Thanks in advance > > > > Dave > >