user maintenance informix database
Baskaran (medkba) asked how Informix database users are created and whether OS users are required. Art Kagel said OS users are recognized by the server. John Miller III said that in versions 11 and 12 users can also be created in the database, with an OAT wizard. On 11.50FC9 without OAT, Art advised using the CREATE USER statement.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All, How informix database user creation? Do we need to create OS user for the database access? Thank you very much --001a11c23c88aef16704e90659cb
You can use OS users and they will be recognized by the server, yes. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Oct 18, 2013 at 12:23 PM, medkba <medkba@gmail.com> wrote: > Hi All, > > How informix database user creation? Do we need to create OS user for the > database access? > > Thank you very much > > --001a11c23c88aef16704e90659cb > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0115fe1e481a7604e90686f6
You should always include the your server version in the ques= tion as the answer depends on the version. You can create OS users, = or you can create users in the database for the version 11 & 12 product= s. The OAT tool has a wizard to walk you though creating database = users. John F. Miller III STSM, Lead Architect miller= 3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) -----ids-bounces@iiug.org wrote: -----<= br> >To: ids@iiug.org >From: "medkba" >Sent by: ids-boun= ces@iiug.org >Date: 10/18/2013 09:24AM >Subject: user maintenan= ce informix database [31756] > >Hi All, How informix databas= e user creation? Do we need to create >OS user for the database acce= ss? Thank you very much >--001a11c23c88aef16704e90659cb >****= ***************************************************************** >**= ******** Forum Note: Use "Reply" to post a response in the >discus= sion forum. =
Sorry, It is a verison 11.50FC9 and I don't install OAT tool. Thank you very much Regards Baskaran On Sat, Oct 19, 2013 at 9:17 PM, John Miller iii <miller3@us.ibm.com> wrote: > You should always include the your server version in the ques= tion as > > the answer depends on the version. > > You can create OS users, = or you can create users in the database for > > the version 11 & 12 product= s. The OAT tool > > has a wizard to walk you though creating database = users. > > John F. Miller III > > STSM, Lead Architect > > miller= 3@us.ibm.com > > 503-747-1366 > > IBM Informix Dynamic Server (IDS) > > -----ids-bounces@iiug.org wrote: -----<= br> > > >To: ids@iiug.org > > >From: "medkba" > > >Sent by: ids-boun= ces@iiug.org > > >Date: 10/18/2013 09:24AM > > >Subject: user maintenan= ce informix database [31756] > > > > > >Hi All, How informix databas= e user creation? Do we need to create > > >OS user for the database acce= ss? Thank you very much > > >--001a11c23c88aef16704e90659cb > > >****= > > ***************************************************************** > > >**= ******** Forum Note: Use "Reply" to post a response in the > > >discus= sion forum. = > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1133a57a6cbcdb04e91a32ba
You don't need OAT, look up the CREATE USER statement. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Oct 19, 2013 at 12:03 PM, medkba <medkba@gmail.com> wrote: > Sorry, It is a verison 11.50FC9 and I don't install OAT tool. > > Thank you very much > > Regards > Baskaran > > On Sat, Oct 19, 2013 at 9:17 PM, John Miller iii <miller3@us.ibm.com> > wrote: > > > You should always include the your server version in the ques= tion as > > > > the answer depends on the version. > > > > You can create OS users, = or you can create users in the database for > > > > the version 11 & 12 product= s. The OAT tool > > > > has a wizard to walk you though creating database = users. > > > > John F. Miller III > > > > STSM, Lead Architect > > > > miller= 3@us.ibm.com > > > > 503-747-1366 > > > > IBM Informix Dynamic Server (IDS) > > > > -----ids-bounces@iiug.org wrote: -----<= br> > > > > >To: ids@iiug.org > > > > >From: "medkba" > > > > >Sent by: ids-boun= ces@iiug.org > > > > >Date: 10/18/2013 09:24AM > > > > >Subject: user maintenan= ce informix database [31756] > > > > > > > > > >Hi All, How informix databas= e user creation? Do we need to create > > > > >OS user for the database acce= ss? Thank you very much > > > > >--001a11c23c88aef16704e90659cb > > > > >****= > > > > ***************************************************************** > > > > >**= ******** Forum Note: Use "Reply" to post a response in the > > > > >discus= sion forum. = > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1133a57a6cbcdb04e91a32ba > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b3a836af891cc04e9206e86