Re: Public access to database

Quoting Reo F. Lasmana... > > > I would like to ask if anyone can help me with setting up the database > public accessible. > > What happen was that after the welcome menu of this database and the menu > option invoke, I get the following general error pretty much: > > Program stopped at "user_info.4gl", line number 220. > SQL Statement error number -242. > Could not open database table (aa4cs.ct_tb). > SYSTEM error number -13 > Permission denied > You didn't say if you are using OnLine or SE. Regardless of which engine you are using, you need to execute a GRANT CONNECT TO PUBLIC in Query-Language after creating the database. If you are using SE, make sure that the permissions on the Unix files for the database are correct. The ".dbs" directory permissions should look like "drwxrwx---" and the files in the ".dbs" directory should look like "-rw-rw----". Also, "informix" should be the group for the ".dbs" directory and all it's files. Oh, and make sure the person who created the database is the owner of the ".dbs" directory and all it's files. DAS -- Dave Snyder @ Bell Atlantic - Philadelphia, PA WORK: ddx85qr@boots.bell-atl.com HOME: dave@das13.snide.com