User Data Maintenance users

[Jani Tamminen]

We run DB2 UDB v8.1 on Windows. How do I find the list of all users that
have the following privileges:

1. User Data Maintenance
2. System Tabale Maintenance

[Knut Stolze]

Jani Tamminen wrote:

We run DB2 UDB v8.1 on Windows. How do I find the list of all users that
have the following privileges:

1. User Data Maintenance
I guess you are interested in the users that have INSERT, UPDATE, DELETE and
CONTROL privileges on tables? Query the catalog view SYSCAT.TABAUTH.
2. System Tabale Maintenance

By "system tables" do you mean the database catalog? There is a set of
privileges for schemata, triggers, functions and the like. Have a look at
the proper catalog view to determine which user or group has privileges on
those objects and also query SYSCAT.DBAUTH to get the information which
user (or group) has which database-wide privileges.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany