Create user in Informix Dynamic Server
Posted in 2000
Topics: General Discussion
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?
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.
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? > > > > > > >
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?
>