Re: ADMIN_USER_MODE_WITH_DBSA

I know this is not directly responsive to your problem, and I'm not Windows savvy enough to answer that directly, but have you thought about moving the server to a Linux box? Far easier to manage in my opinion and more reliable to boot. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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 Tue, May 13, 2014 at 7:51 AM, BillHatVerizon <garage_dba@verizon.net>wrote: > IBM Informix Dynamic Server Version 12.10.TC2IE > > But buildsmi.sql does not work as informix . > Maybe something is messed up in the registry? > Is there something in the registry as to who has DBSA privilege? > > -----Original Message----- > From: BENJAMIN THOMPSON > Sent: Tuesday, May 13, 2014 5:32 AM > To: ids@iiug.org > Subject: Re: ADMIN_USER_MODE_WITH_DBSA [32994] > > Hi, > > What version of Informix are you running? > > The purpose of the ADMIN_USER_MODE_WITH_DBSA and ADMIN_MODE_USERS > parameters > is to determine who can connect to the instance in single user mode. > > Docs here: > > > http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.adref. doc%2Fids_adr_0018.htm > > They talk about "administration mode" but this means "single-user mode", > aka > "onmode -j", and it does not imply any administrator privileges other than > being able to make a connection in this mode (if you have "grant connect"). > > For many purposes you can log in as user "informix" to sysmaster and run as > a > one-off "grant dba to administrator;" and then do admin function as > "administrator" but from memory I don't think this works fully in the > system > databases before version 11.70. > > For "buildsmi.sql" specifically I am pretty sure this will not work unless > you > are "root" or "informix". Check out > http://www-01.ibm.com/support/docview.wss?uid=swg21660680 > > Ben. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113457dc97830904f947d075

would love to, but the PTB would not understand. -----Original Message----- From: Art Kagel Sent: Tuesday, May 13, 2014 8:12 AM To: ids@iiug.org Subject: Re: ADMIN_USER_MODE_WITH_DBSA [33001] I know this is not directly responsive to your problem, and I'm not Windows savvy enough to answer that directly, but have you thought about moving the server to a Linux box? Far easier to manage in my opinion and more reliable to boot. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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 Tue, May 13, 2014 at 7:51 AM, BillHatVerizon <garage_dba@verizon.net>wrote: > IBM Informix Dynamic Server Version 12.10.TC2IE > > But buildsmi.sql does not work as informix . > Maybe something is messed up in the registry? > Is there something in the registry as to who has DBSA privilege? > > -----Original Message----- > From: BENJAMIN THOMPSON > Sent: Tuesday, May 13, 2014 5:32 AM > To: ids@iiug.org > Subject: Re: ADMIN_USER_MODE_WITH_DBSA [32994] > > Hi, > > What version of Informix are you running? > > The purpose of the ADMIN_USER_MODE_WITH_DBSA and ADMIN_MODE_USERS > parameters > is to determine who can connect to the instance in single user mode. > > Docs here: > > > http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.adref. doc%2Fids_adr_0018.htm > > They talk about "administration mode" but this means "single-user mode", > aka > "onmode -j", and it does not imply any administrator privileges other than > being able to make a connection in this mode (if you have "grant > connect"). > > For many purposes you can log in as user "informix" to sysmaster and run > as > a > one-off "grant dba to administrator;" and then do admin function as > "administrator" but from memory I don't think this works fully in the > system > databases before version 11.70. > > For "buildsmi.sql" specifically I am pretty sure this will not work unless > you > are "root" or "informix". Check out > http://www-01.ibm.com/support/docview.wss?uid=swg21660680 > > Ben. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113457dc97830904f947d075 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Don't tell them - say it a GUI'less version of Windows :) > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > BillHatVerizon > Sent: Tuesday, May 13, 2014 9:15 AM > To: ids@iiug.org > Subject: Re: ADMIN_USER_MODE_WITH_DBSA [33004] > > would love to, but the PTB would not understand. > > -----Original Message----- > From: Art Kagel > Sent: Tuesday, May 13, 2014 8:12 AM > To: ids@iiug.org > Subject: Re: ADMIN_USER_MODE_WITH_DBSA [33001] > > I know this is not directly responsive to your problem, and I'm not Windows > savvy enough to answer that directly, but have you thought about moving > the > server to a Linux box? Far easier to manage in my opinion and more > reliable to boot. > > Art > > Art S. Kagel, Principal Consultant > ASK Database Management > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on 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 Tue, May 13, 2014 at 7:51 AM, BillHatVerizon > <garage_dba@verizon.net>wrote: > > > IBM Informix Dynamic Server Version 12.10.TC2IE > > > > But buildsmi.sql does not work as informix . > > Maybe something is messed up in the registry? > > Is there something in the registry as to who has DBSA privilege? > > > > -----Original Message----- > > From: BENJAMIN THOMPSON > > Sent: Tuesday, May 13, 2014 5:32 AM > > To: ids@iiug.org > > Subject: Re: ADMIN_USER_MODE_WITH_DBSA [32994] > > > > Hi, > > > > What version of Informix are you running? > > > > The purpose of the ADMIN_USER_MODE_WITH_DBSA and > ADMIN_MODE_USERS> > parameters > > is to determine who can connect to the instance in single user mode. > > > > Docs here: > > > > > > > > http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.i > bm.adref.doc%2Fids_adr_0018.htm > > > > They talk about "administration mode" but this means "single-user mode", > > aka > > "onmode -j", and it does not imply any administrator privileges other than > > being able to make a connection in this mode (if you have "grant > > connect"). > > > > For many purposes you can log in as user "informix" to sysmaster and run > > as > > a > > one-off "grant dba to administrator;" and then do admin function as > > "administrator" but from memory I don't think this works fully in the > > system > > databases before version 11.70. > > > > For "buildsmi.sql" specifically I am pretty sure this will not work unless > > you > > are "root" or "informix". Check out > > http://www-01.ibm.com/support/docview.wss?uid=swg21660680 > > > > Ben. > > > > > > > > > > ********************************************************** > ********************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ********************************************************** > ********************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a113457dc97830904f947d075 > > > ********************************************************** > ********************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ********************************************************** > ********************* > Forum Note: Use "Reply" to post a response in the discussion forum.