|
Problem IC98911
|
Status: Closed |
DB2 CACHES GROUP MEMBERSHIP OF LOCALSYSTEM (SYSTEM) UNTIL NEXT INSTANCE RECYCLING. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
The DB2 server enumerates and saves the groups that the
LocalSystem (SYSTEM) account is a member of, but unlike other
accounts, the cache is never refreshed. This creates a problem
when users attempt to grant SYSTEM additional privileges by
adding SYSTEM to groups that have DB2 privileges after the DB2
server has started. Once DB2 has populated the cache, it will
not be aware of group membership changes to SYSTEM afterwards.
To remedy, restart DB2 after making the group membership change. |
| Problem Summary: |
The DB2 server enumerates and saves the groups that the
LocalSystem (SYSTEM) account is a member of, but unlike other
accounts, the cache is never refreshed. This creates a problem
when users attempt to grant SYSTEM additional privileges by
adding SYSTEM to groups that have DB2 privileges after the DB2
server has started. Once DB2 has populated the cache, it will
not be aware of group membership changes to SYSTEM afterwards.
To remedy, restart DB2 after making the group membership change. |
| Local Fix: |
Restart the db2 instance. |
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Cancun Release 10.5.0.4 |
| Workaround |
Restart the db2 instance. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.01.2014
15.09.2014
15.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
