A User Authorization is missing in the PK-UA report

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

After granting Execute authority to a package using GRANT EXECUTE ON PACKAGE collection-id.*, the granted authorization is not reported in the PK-UA report in RC/Query.

Environment

Release : 20.0

Component : RC/Query for DB2 for z/OS

Resolution

As the GRANT was executed on the collection and not explicitly on a particular package, then you will need to leave the package field as '*'.

You should then see package name '*' at the top of the PK-UA report and the granted user authorization will be displayed.

Additional Information

When you perform the GRANT on PACKAGE collection-id.*, this is stored in SYSPACKAUTH with package NAME "*". It does not result in a grant on an explicit package name. This is because the grant applies to every package in the indicated collection. This includes packages that currently exist and future packages.