|
Problem IT34844
|
Status: Closed |
DB2LOOK -XD DOES NOT SHOW ALL DATABASE AUTHORIZATION STATEMENTS GRANTED AT DATABASE CREATION TIME
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
According our documentation following database authorities are
granted, but missing in db2look -xd output:
" The database creator is granted the following authorities:
ACCESSCTRL
DATAACCESS
DBADM
SECADM
In a non-restrictive database, the special group PUBLIC is
granted the following authorities:
CREATETAB
BINDADD
CONNECT
IMPLICIT_SCHEMA"
This Apar will add this information to db2look -xd output.
Below is an example if CREATOR of the database was USER "HLEE":
----------------------------------------
-- Authorization Statements on Database
----------------------------------------
GRANT DBADM WITHOUT DATAACCESS WITHOUT ACCESSCTRL ON DATABASE
TO USER "HLEE " ;
GRANT SECADM ON DATABASE TO USER "HLEE " ;
GRANT DATAACCESS ON DATABASE TO USER "HLEE " ;
GRANT ACCESSCTRL ON DATABASE TO USER "HLEE " ;
GRANT CREATETAB ON DATABASE TO PUBLIC ;
GRANT BINDADD ON DATABASE TO PUBLIC ;
GRANT CONNECT ON DATABASE TO PUBLIC ;
GRANT IMPLICIT_SCHEMA ON DATABASE TO PUBLIC ; |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.1 Fix Pack m4fp6 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.1 Fix Pack m4fp6 or later *
**************************************************************** |
| Comment |
First fixed in DB2 Version 11.1 Fix Pack m4fp6 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.11.2020
15.03.2021
15.03.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
