DBA Privileges
Deepak Joshi asked how to list users with DBA privileges in Informix 7.13 on HP-UX 10.01. Art Kagel suggested SELECT * FROM sysusers WHERE usertype = 'D' in the database concerned. Lloyd S and Susan Jones suggested taking a dbschema with dbschema -d database -p all. No confirmation from the poster appears.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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
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.
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.