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] October 8, 2003 6:21 AM
To: [Email Address Removed] 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]


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