Re: Fixing Permissions Problem

Douglas R. Probst (doug@catseye.pha.pa.us) 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. : I have been bit more than a few time with this. No. Do this and you lose all security--anybody can read/write the database files! All the database files must belong to group "informix" and be mode 660 (files) or 770 (directories). The database engine, sqlexec, runs suid root initially so it can do a ulimit() to increase its memory and file limits. It also runs sgid informix so it has read/write permission on all database files: chown root sqlexec chgrp informix sqlexec chmod 6755 sqlexec -- Jeff Sturm ZenaComp Incorporated jsturm@zenacomp.com