user maintenance informix database
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