Used to enforce package participant security in the data presented in reports.

A query of KDLV_PARTICIPANT_CHECK_V will return the packages in Deployment Management of which a particular user is a participant. This view can be joined into report queries to check whether the user running the report is a participant of packages that are enforcing participant-only viewing restriction.


Consider a report that is to return the description of open packages in Deployment Management. To restrict reported information to only those packages that the user running the report is a participant of, you must design the report so that it requires a valid username as an input field.

Note: The methodology and support for this type of report input will vary between reporting systems. Consult the documentation for the reporting system you are using for specific instructions.

Assuming the input username is available as REPORT_USER, include the following SQL fragment in the report query:

FROM   kdlv_participant_check_v kpc
WHERE  kpc.username = REPORT_USER
AND    kpc.package_id = ...

Including this fragment in the full SQL statement might look as follows (with an example username of fjohnson):

SELECT p.package_id,
FROM   mpkg_packages p,
       kdlv_participant_check_v kpc
WHERE  p.package_status not like 'Closed%'
AND    kpc.username = 'fjohnson'
AND    kpc.package_id = p.package_id;

If a Deployment Management workflow does not enforce package participant security, then all packages using this workflow will be returned by KDLV_PARTICIPANT_CHECK_V as viewable.