Re: DB access from multiple server permission problem

Gary Quiring wrote: > I have two servers running Informix 7.31. Some new code was written to > access a database from a different server. It only works if I add that > user to the Unix system. Is there a way of opening up the database to > allow anyone to access it without the user being setup on that server. > > I have tried grant connect to public on the server but it did not help. > > Thanks > Gary Quiring I believe that the answer is NO. I believe that 7.x uses UNIX login/password for connect authentication, which means that, yes, you've got to create a UNIX account for the user on the UNIX system. Assuming this, if you can create a single UNIX account that 'anyone' can use. With 7.x, this issue, authentication, has nothing to do with with the granting or revoking of permissions on a database or its tables. Vic