A User Authorization is missing in the PK-UA report
search cancel

A User Authorization is missing in the PK-UA report


Article ID: 239490


Updated On:


RC/Query for DB2 for z/OS


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.


Release : 20.0

Component : RC/Query for DB2 for z/OS


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.