KDLV_PARTICIPANT_CHECK_V

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.

Sample

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.

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,
       p.package_status
       p.package_description
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.