DB2 - Problem description
Problem IT36847 | Status: Closed |
WHEN DB2_ALTERNATE_GROUP_LOOKUP=GETUSERATTR, A USER'S PRIMARY GROUP MAY NOT BE REPORTED BY DB2. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
When DB2_ALTERNATE_GROUP_LOOKUP is set to GETUSERATTR, and a user is not an explicit member of their primary group, the primary group is not reported by Db2 and Db2 will not consider the user to be a member of the primary group. This may result in privilege or authority errors such as SQL1060N, SQL1092N, SQL0552N or SQL0551N. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 systems AIX platforms at service levels Version 11.5 * * GA to 11.5.6 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Local Fix: | |
Explicitly add the affected user as a member of their primary group. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All DB2 systems AIX platforms at service levels Version 11.5 * * GA to 11.5.6 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5 FP7 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.05.2021 23.11.2021 23.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |