[Help] Connect to informix without a password...
Posted in 2001
Topics: Installation, Setup & Upgrades, Security, Permissions & Auditing, Platform-Specific Issues
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.