The REAL method would be to go thru all the AUTH tables and look at the
column GRANTEETYPE.

This column (CHAR 1) has two values U/G. U is for user and G is for
Group.
You may do a union of all the tables GRANTEE where GRANTEETYPE = 'G' ;
Rahul

>>> "Bullerwell, Edward" <edward.[Email Address Removed] 8/10/2003
11:59:32 pm >>>

One quick method, use db2look and grep for grants on groups ...
ie. GRANT CONNECT ON DATABASE TO GROUP "ZZZZZZ" ;

-----Original Message-----
From: Tim James McConechy [mailto:tim.[Email Address Removed]
Sent: October 8, 2003 6:21 AM
To: [Email Address Removed]
Subject: Query to get a listing of all DB Groups


Hi,
I'm looking for a query which will get me all the DB groups on a
particular database.
This should return the names like it does in the control center....

I heard from a colleague that you need to make a stored procedure that
searches in the OS.

Surely someone has done this?

BR

Tim McConechy
RunTime - a division of Geac Enterprise Solutions
Tirsbaek Gods, Tirsbaekvej 139
DK-7120 Vejle East
Phone: +45 70 24 42 00 (direct +45 70 24 42 69)
Fax: +45 75 81 63 70
E-mail: [Email Address Removed]





**********************************************************************
***** IMPORTANT INFORMATION *****
This document should be read only by those persons to whom
it is addressed and its content is not intended for use by
any other persons. If you have received this message in
error, please notify us immediately. Please also destroy and
delete the message from your computer. Any unauthorised form
of reproduction of this message is strictly prohibited.
St.George is not liable for the proper and complete transmission
of the information contained in this communication, nor for any
delay in its receipt.
**********************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page