|
Problem IC68829
|
Status: Closed |
ONLY THE BUILD-IN SYSTEM ACCOUNT HAS THE AUTHORITIIES TO ACCESS AND GRANT ACCESS TO THE DATABASES CREATED IN A SILENT INSTALL |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
For a database specified in the response file to be created
during a silent install, its creator is the build-in SYSTEM
account on Windows. Because of the changes introduced by
Separation of Duties in the V97GA release, only the creator
(SYSTEM account in this case) has the
SECADM/DBADM/ACCESSCTRL/DATAACCESS to that database. Thus, other
users, even a member in the local Administrators group, do not
have the access and do not have the authority to grant db access
to other users. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 Server products on windows *
****************************************************************
* PROBLEM DESCRIPTION: *
* For a database specified in the response file to be created *
* *
* during a silent install, its creator is the build-in SYSTEM *
* *
* account on Windows. Because of the changes introduced by *
* *
* Separation of Duties in the V97GA release, only the creator *
* *
* (SYSTEM account in this case) has the *
* *
* SECADM/DBADM/ACCESSCTRL/DATAACCESS to that database. Thus, *
* other *
* users, even a member in the local Administrators group, do *
* not *
* have the access and do not have the authority to grant db *
* access *
* to other users. *
****************************************************************
* RECOMMENDATION: *
* The work-around for this problem is: *
* To drop the database created during a silent install then *
* recreate it, or *
* not to specify database in the response file to be *
* created in the silent install. *
* *
* This problem will be fixed in the V97FP3 release. *
**************************************************************** |
| Local Fix: |
1). Drop the database created during a response file based
silent install, and then recreate it.
2). Do not specify a database in the response file to be created
during the silent install |
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 |
This problem will be fixed in the V97FP3 release. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC68832
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.05.2010
16.09.2010
16.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
