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

I figured out the problem - thanks for all the responses! It's an ANSI databse and I needed to specufy the username (of the owner) in front of each table nmae. AN additional problem is that the owner name is case-sensitive, so I had to qupte it to preserve the case My next problem is trying to get a well-formed SQL statement from a construct by nmae statement. (it doesn't want to add the username to the front of the table name)) Thnks again, Kirstie On Sat, 3 Feb 1996, Tony Tyrwhitt-Drake wrote: > In article <Pine.A32.3.91.960202154016.53060B-100000@acs4.acs.ucalgary.ca>, Kirstie Anna Fisher <kafisher@acs.ucalgary.ca> says: > > > >I made a database and wrote a 4gl front-end to access it. It works > >great for me but nobody else can use it . > > > >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) > > > >The other users can run the 4gl program but when they query the > >databse, it returns nothing. > > Can the other users access the database using ISQL or dbaccess? > > Have the other users got select permission on the tables as well > as insert etc? This is in addition to granting connect to public > on the database as a whole. > > Can you tell us what error messages other users get, or do they get > absolutely nothing?