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

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 drwxdrwx--- somedb.dbs > > The other users can run the 4gl program but when they query the > databse, it returns nothing. Does the program actually fall over with a database not found error, or 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). Hope this helps. Steve -- ----------------------------------------------------------------------------- EnsignData Ltd. - Informix and Tetra Accounting systems consultancy +44 1634 577054 Steve Weet steve@weet.demon.co.uk