A fix is available
APAR status
Closed as new function.
Error description
New Function
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 13 for z/OS users of the RACF/Db2 * * Access Control Module (DSNXRXAC). * **************************************************************** * PROBLEM DESCRIPTION: * * Users with database DBADM authority * * cannot drop views created for other * * users. * **************************************************************** * RECOMMENDATION: * **************************************************************** Users with database DBADM authority can create views for other users when additional requirements are met. However, the same database administrator who created the view cannot drop the view.
Problem conclusion
Temporary fix
Comments
DSNXRXAC has been changed to allow users with DBADM authority on a database that contains at least one of the tables identified in the fullselect of the CREATE VIEW statement to drop a view when XAPLDBSP is set. The Db2 product documentation is updated for these changes. For more information, see the description of this APAR in: https://www.ibm.com/docs/en/SSEPEK_13.0.0/ wnew/src/tpc/db2z_13_newfunctionapars.html https://www.ibm.com/docs/en/db2-for-zos/ 13?topic=reference-view-privileges
APAR Information
APAR number
PH54936
Reported component name
DB2 RACF EXIT Z
Reported component ID
5740DRE00
Reported release
D10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-06-05
Closed date
2023-06-28
Last modified date
2023-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI92531
Modules/Macros
DSNXRXAC
Fix information
Fixed component name
DB2 RACF EXIT Z
Fixed component ID
5740DRE00
Applicable component levels
RD10 PSY UI92531
UP23/07/06 P F307
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 August 2023