|
Problem IC91304
|
Status: Closed |
PACKAGEAUTH contains records WITH GRANTEE='SYSIBM' and GRANTEETYPE='S' |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When executing "SELECT * FROM SYSIBMADM.AUTHORIZATIONIDS", one
may see AUTHIDTYPE incorrectly set to 'S'
AUTHID AUTHIDTYPE
---------------------------------------------
SYSIBM S
An AUTHIDTYPE of 'S' represents a SYSTEM type grantee. The only
valid values for AUTHIDTYPE are U (user), R (Role), and G
(group).
This is because DB2 is incorrectly inserting records into
PACKAGEAUTH with grantee='SYSIBM' and granteetype='S'. SYSIBM is
a system user and it already has implicit privilege on package
operations, thus the extra records in PACKAGEAUTH are not
needed. This poses no risk or vulnerabilities with regards to
DB2 security. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v10.1 FP3. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Fixed in DB2 v10.1 FP3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.04.2013
02.10.2013
02.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
