Oninit cdi / Archive
Talk to an expert →

authentification

Posted in 2000

Topics: General Discussion

Martin A. Marques — — source: Informix-list mailing list archive (1991-1998)

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 -----------------------------------------------------------------

↪ replying to Martin A. Marques
Edward Rosenthal — — source: Informix-list mailing list archive (1991-1998)

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 > -----------------------------------------------------------------

↪ replying to Martin A. Marques
mars1972@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to Martin A. Marques
mars1972@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

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.