[Help] Connect to informix without a password...
Sangho Cho (Informix 7.2 on AIX) found clients could connect without a password and revoking CONNECT from public and reinstalling did not help. Wolfgang Zager blamed AIX or setnet host settings; bob blamed sqlhosts/.rhosts trust; Art Kagel said to remove client trust on the server and in users' .rhosts files so a login and password are required. No confirmation of the result.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi. I am using Informix 7.2 on IBM AIX Machine. After Some day, Client users can connect to Informix without a password. How can do that? I do not want this situation. So I revoke the connect privilege from public user, restart system, re-install informix server, but problems are remainning unchanged. Please help me solve it.
since AIX is responsible for connections, the problem must arise from it. another possiblity maybe, if the client is a windows-machine, you changed host-definition in setnet. wolfgang Sangho Cho schrieb: > > Hi. > > I am using Informix 7.2 on IBM AIX Machine. > After Some day, Client users can connect to Informix without a password. > > How can do that? > I do not want this situation. > > So I revoke the connect privilege from public user, restart system, > re-install informix server, > but problems are remainning unchanged. > > Please help me solve it. -- ******************************************************************************* * Any opinions written in this e-mail are my own. They may not correspond to * * those of my company. * ******************************************************************************* * Wolfgang Zager Berghauser Str. 104 * * BAB Data-Systems GmbH D-42349 Wuppertal * * Abt. Programmierung Tel. : +49 202 479870 * * Fax : +49 202 470035 * * E-Mail: zager@gmx.de * *******************************************************************************
2c says that your setup in the sqlhosts file is responsible, the default config that the MANUAL recommends is to setup the unit so that the .rhosts mechanism is used... bad bad bad bad brett In article <3A5DA9CC.618EC412@gmx.de>, zager@gmx.de says... > since AIX is responsible for connections, the problem must arise from > it. > another possiblity maybe, if the client is a windows-machine, you > changed > host-definition in setnet. > > wolfgang > > Sangho Cho schrieb: > > > > Hi. > > > > I am using Informix 7.2 on IBM AIX Machine. > > After Some day, Client users can connect to Informix without a password. > > > > How can do that? > > I do not want this situation. > > > > So I revoke the connect privilege from public user, restart system, > > re-install informix server, > > but problems are remainning unchanged. > > > > Please help me solve it. > >
In article <93jqis$kn$1@news1.kornet.net>, "Sangho Cho" <shcho@seoul.co.kr> wrote: You must revoke permission to user public for "each table" in database and revoke connect to public, then Grant permission to each user in database for each table. Any table with permission for public can be used for any user > Hi. > > I am using Informix 7.2 on IBM AIX Machine. > After Some day, Client users can connect to Informix without a password. > > How can do that? > I do not want this situation. > > So I revoke the connect privilege from public user, restart system, > re-install informix server, > but problems are remainning unchanged. > > Please help me solve it. > > Sent via Deja.com http://www.deja.com/
Make sure the client machines are not trusted on the server or in the users' .rhosts files on the server. Then the user will be required to connect with a login name and password. Art S. Kagel Sangho Cho wrote: > > Hi. > > I am using Informix 7.2 on IBM AIX Machine. > After Some day, Client users can connect to Informix without a password. > > How can do that? > I do not want this situation. > > So I revoke the connect privilege from public user, restart system, > re-install informix server, > but problems are remainning unchanged. > > Please help me solve it.