Share this page

# 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.

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,
           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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: