Re: Fixing Permissions Problem

}From: rmcall@on-ramp.ior.com (Rob McAllister) }Date: Tue, 21 Nov 1995 23:26:41 GMT }X-Informix-List-Id: <news.19103> } }kcj@netcom.com (Kate Juliff) 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 } }The problem is probably one of two things. 1) This user belongs to a }different unix group, I think it should be group "informix" (User }account setup problem). 2) If the user was added to this new machine }with a different login name, Informix will not recognize him (Informix }stores user names not user ID's). Sorry, but I can't let this permissions 'solution' go without comment either... (1) No! The one group that no ordinary user should belong to is group informix. If users belong to group informix, they can access any of the database files (read *DESTROY*) without using the Informix tools. Under no circumstances whatsoever should any user other than informix belong to group informix. (2) This is a perfectly valid point, and one which wasn't mentioned previously by anyone else. Marks: 40% overall -- 50% correct, with 30% extra penalty points for the dangerousness of the wrong answer, and 20% extra bonus points for a good second answer. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>