By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

User Data Maintenance users

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.