Re: Q: Nobody else can read my database - why? - more

Have you checked: 1. Installed permissions of the software? sqlexec should be owned by root, belong to group informix, and should be executable with SUID and SGID bits set. 2. Directory permissions leading to the place where the database is kept. In general, every directory leading to the database directory should have x (search) permission for others. / root root 755 /home root root 755 /home/you you group 755 /home/you/dbase you group 755 /home/you/dbase/database.dbs you informix 770 3. Is your database MODE ANSI? If so, you must always use the owner name when you refer to the tables in the database. If you don't, the system assumes you are referring to your own tables, and puts your name in front of the table, and then can't find the table unless you happened to create it. Since root appeared to be able to access the database but then couldn't find tables, I think that this (MODE ANSI) is probably your problem. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: Kirstie Anna Fisher <kafisher@acs.ucalgary.ca> }Date: Mon, 5 Feb 1996 09:45:19 -0700 }X-Informix-List-Id: <news.20924> } }Thanks for the replies - no luck so far however. } }The suggestions that I got were to set the DBPATH and run the command: }grnat connect to public. No dice. } }ANother suggestion was to look at the WHENEVER ERROR statement since it }might be masking the treu problem. I don't use a WHENEVER ERROR statement }when querying the data (THe 4gl program doesn't fail or die or anything - }it just doesn't return any data) but ... } }I went into dbaccess as root (_NOT_ the creator of the database) and I saw }the database just fine. WHen I tried a simple query however, I got: }root.user table not in database. SO, this leads me to believe that it is }prepending the username to the table request and since the creator was }knepperm, the table is actually called knepperm.user, it isn't finding it. } }So, how do I look at the table? (I've tried querying on knepperm.user and }it isn't found) } }Thanks }Kirstie } }On 3 Feb 1996, Steve Weet wrote: } }> In message <Pine.A32.3.91.960202154016.53060B-100000@acs4.acs.ucalgary.ca> Kirstie Anna Fisher writes: }> > I've playted around with access rules and stuff - I made it avallable }> > to public, etc... I even went in and changed the Unix permsissions on }> > the databse and higher directories to rwxrwxrwx (when I got }> > desperate - they've been changed back since) }> }> I assume that the statement used was grant connect to public. This should }> be sufficient. When the permissions were changed back they should have been }> a permissions type error, or does it run OK. CHeck the following }(...) }> What is the setting of DBPATH, for you and your users. Informix will use }> DBPATH to find the database and you could have two databases with the same }> name. }(...) }> If this is not the case then check the setting of the WHENEVER ERROR }> statements in your code. This may be masking the problem. Also check the }> permissions along the path to your database. All directories down the path }> should have execute permission (and problably read as well). }(...) }> Steve