Re: Fixing Permissions Problem

Douglas R. Probst wrote: > > In article <kcjDI664n.KCM@netcom.com>, Kate Juliff <kcj@netcom.com> wrote: > } > }I have transfered Informix SE and SQL to a new machine (I upgraded from a > }486 to Pentium.) and I can access my database just fine. However, even > }though I have granted permission to another user, he cannot access my > }database (he could before.). I think I have everything set up properlt > }but there must be something wrong somewhere. I don't want to reinstall > }after all the trouble I had with it the first time. As I can access the > }database and as everything other than the permissions problem is OK, I'd > }like to get around this. Any suggestions, > } > }--Kate > > Check the permissions on the .dbd .dat &.idx files (Unix perm.) > They must be 666 for everyone to have read and write permission. Buzzzzzzz. Don't do this unless you don't mind your users being able to randomly trash your data. The important concern is that the engine (sqlexec) is setuid root/setgid informix and that the .dat and .idx files are 660, owned by their creator and group informix. This alows access via the engine but disalows access direct to the files (asuming the .dbs is correctly set and none of your users are in group informix). > I have been bit more than a few time with this. With 666 permissions your asking to be swallowed whole! Cosmo -- simond@informix.com