Oninit cdi / Archive
Talk to an expert →

DBA Privileges

Posted in 2010

Topics: Server Administration, Platform-Specific Issues

DEEPAK JOSHI — — source: IIUG Forums & Mailing Lists

Hello All, Is there any way to check how many users having dba privileges in informix 7.13? other than informix user. Informix 7.13 is running on hp-UX 10.01. Regards, DJ

↪ replying to DEEPAK JOSHI
Art Kagel — — source: IIUG Forums & Mailing Lists

In the database in question: SELECT * FROM sysusers WHERE usertype = 'D'; Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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 Tue, Aug 3, 2010 at 2:48 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote: > Hello All, > > Is there any way to check how many users having dba privileges in informix > 7.13? other than informix user. Informix 7.13 is running on hp-UX 10.01. > > Regards, > DJ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016367fba5ce8f5bc048cf018c4

↪ replying to DEEPAK JOSHI
Lloyd S — — source: IIUG Forums & Mailing Lists

Take a dbschema of the database. dbschema -d -p all Lloyd On Wed, 04 Aug 2010 00:18:15 +0530 wrote >Hello All, Is there any way to check how many users having dba privileges in informix 7.13? other than informix user. Informix 7.13 is running on hp-UX 10.01. Regards, DJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to DEEPAK JOSHI
Jones, Susan — — source: IIUG Forums & Mailing Lists

dbschema -d databasename -p all|more -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DEEPAK JOSHI Sent: Tuesday, August 03, 2010 2:48 PM To: ids@iiug.org Subject: DBA Privileges [20728] Hello All, Is there any way to check how many users having dba privileges in informix 7.13? other than informix user. Informix 7.13 is running on hp-UX 10.01. Regards, DJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.