authentification
Martin A. Marques asked how Informix authenticates database connections. Edward Rosenthal answered that the user needs an operating system account, CONNECT privilege on the database and table privileges, and referred to an earlier Art Kagel article. Another poster clarified that the OS verifies the user and internal GRANT permissions control databases and tables.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
hello. I would like to know how informix authenticates when someone tries to connect to certain DB. Does it authenticate itself with the OS, or does it have a database with all the authentification info of the users (like in MySQL)? Thanks -- "And I'm happy, because you make me feel good, about me." - Melvin Udall ----------------------------------------------------------------- Mart'n Marqu's email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------
the operating system has to know the someone ( have an account on) the machine. the database has to have 'connect' privileges. the tables have to have 'select..' privileges. there is a more thorough answer to your question in a previous article by Art Kagel. "Martin A. Marques" wrote: > hello. > I would like to know how informix authenticates when someone tries to connect > to certain DB. Does it authenticate itself with the OS, or does it have a > database with all the authentification info of the users (like in MySQL)? > > Thanks > > -- > "And I'm happy, because you make me feel good, about me." - Melvin Udall > ----------------------------------------------------------------- > Martín Marqués email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > -----------------------------------------------------------------
OS In article <8j7omu$5uq$1@news.xmission.com>, "Martin A. Marques" <martin@math.unl.edu.ar> wrote: > > hello. > I would like to know how informix authenticates when someone tries to connect > to certain DB. Does it authenticate itself with the OS, or does it have a > database with all the authentification info of the users (like in MySQL)? > > Thanks > > -- > "And I'm happy, because you make me feel good, about me." - Melvin Udall > ----------------------------------------------------------------- > Mart'n Marqu's email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > ----------------------------------------------------------------- > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.
Let me clarify myself. It uses the OS to verify that the user should be able to connect to the machine, but uses internal permissions to verify access to certain tables or databases. In other words, a user may be able to connect to the machine and by default, the database using OS level verification. However, you can set up database level permissions using the GRANT statement. In article <8j7omu$5uq$1@news.xmission.com>, "Martin A. Marques" <martin@math.unl.edu.ar> wrote: > > hello. > I would like to know how informix authenticates when someone tries to connect > to certain DB. Does it authenticate itself with the OS, or does it have a > database with all the authentification info of the users (like in MySQL)? > > Thanks > > -- > "And I'm happy, because you make me feel good, about me." - Melvin Udall > ----------------------------------------------------------------- > Mart'n Marqu's email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > ----------------------------------------------------------------- > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.