|
Problem IC69870
|
Status: Closed |
DB2 CONTROL CENTER FAILS TO REMOVE SOME USERS OR GROUPS. |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
With DB2 9.7, new authorities are introduced :
ACCESSCTRL,DATAACCESS, EXPLAIN, SQLADM, and WLMADM.
If the user (or the group), you are trying to remove, has one of
these authorities, DB2 Control enter will fail without
any error. The user (or the group) will be removed from the list
displayed by DB2 Control Center but not from the database : it
will be displayed again, if you refresh the list of the users
(or groups) or if you restart the tool. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 Control Center *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 FP4 *
**************************************************************** |
| Local Fix: |
To remove the user (or group), you can use the command line
processor instead:
- check the authority by running
db2 select * from sysibm.sysdbauth where grantee = "yyyy"
- remove the corresponding authority for the user or group by
running
db2 revoke xxxx on database from user yyyy
or
db2 revoke xxxx on database from group yyyy
where "xxxx" is the authority and "yyyy" is the group or user
name. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
DB2 9.7 FP4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.07.2010
19.05.2011
19.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
