Create user in Informix Dynamic Server

Posted in 2000

Summary

Victor Rakhmanov, new to IDS, asked how to create another database user besides informix. Mark Steen and Watawinona explained authentication uses operating system users, so add a user to the server machine. Sergey Turin pointed to GRANT and REVOKE in the SQL syntax manual for database and table privileges. Answered.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Rakhmanov, Victor — Mon, 10 Jul 2000 13:02:06 +0400 — source: Informix-list mailing list archive (1991-1998)

Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?

↪ replying to Rakhmanov, Victor

Mark Steen — Mon, 10 Jul 2000 11:02:12 -0500 — source: Informix-list mailing list archive (1991-1998)

default user validation agains OS users, so by creating a user on the database machine, you can (with appropriate permissions) connect to the database as that user. --mark Rakhmanov, Victor wrote: > > Hello all > I&pi0;m new in INS. Could you help me? > I have Database server with one user Informix. > How to create another user to Database? > -- ============================================================== Mark Steen Principal Systems Engineer Informix Software, Inc. 8310 N. Capital of Texas Hwy. Suite 285 Austin, TX 78731 Phone : (512) 342-1022 x-206 FAX : (512) 231-0940 mailto: mark.steen@informix.com ============================================================== Microsoft Windows: Proof that P.T. Barnum was correct.

↪ replying to Rakhmanov, Victor

Watawinona — 10 Jul 2000 20:03:16 GMT — source: Informix-list mailing list archive (1991-1998)

add another user to the system, just like you added your own account - /etc/passwd. Nona >Subject: Create user in Informix Dynamic Server >From: "Rakhmanov, Victor" Victor.Rakhmanov@artificial-life.com >Date: 10.07.00 11:02 W. Europe Daylight Time >Message-id: <119F66596CB2D311BD3100508B4492ED0286A114@johnny.aliferus> > >Hello all >I`m new in INS. Could you help me? >I have Database server with one user Informix. >How to create another user to Database? > > > > > > >

↪ replying to Rakhmanov, Victor

Sergey Turin — Tue, 11 Jul 2000 15:11:50 +0400 — source: Informix-list mailing list archive (1991-1998)

Victor, Please read : Informix guide to SQL Syntax vol.1 ( look for GRANT and REVOKE ) or Informix guide to SQL Tutorial Both manuals are available for download from www.informix.com/answers Informix maintains security on database and table level, so you just need to grant privileges to UNIX users(s). Hope this helpds, Sergey Rakhmanov, Victor <Victor.Rakhmanov@artificial-life.com> wrote in message news:119F66596CB2D311BD3100508B4492ED0286A114@johnny.aliferus... > Hello all > I`m new in INS. Could you help me? > I have Database server with one user Informix. > How to create another user to Database? >