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

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 > -- > ----------------------------------------------------------------------------- > EnsignData Ltd. - Informix and Tetra Accounting systems consultancy > +44 1634 577054 > Steve Weet steve@weet.demon.co.uk