IBM Support

Listing of Programs that Adopt the Authority of the Owner.

How To


Summary

How do you create a report that lists the programs that Adopt the Authority of the Owner of the program.

Objective

Identify programs that Adopt the Authority of the Owner of the program.  

Environment

The information provided on this document is similar to the information created by the Print Adopting Objects (PRTADPOBJ) command. It provides a report with information about objects that adopt authority. 
This document uses the PROGRAM_INFO view to find programs that use adopted authority.

Steps

1) Open the ACS Run SQL Scripts tool 
2) Run the following SQL:
SELECT PROGRAM_LIBRARY,
       PROGRAM_NAME,
       PROGRAM_TYPE,
       PROGRAM_OWNER,
       USER_PROFILE,
       USE_ADOPTED_AUTHORITY,
       TEXT_DESCRIPTION
    FROM QSYS2.PROGRAM_INFO
    WHERE PROGRAM_LIBRARY = 'V6CASTIL'  -- Name of Library. 
    and USER_PROFILE = '*OWNER'
image-20250211103221-1
NOTE: Specify the Name of the Library on the SQL 
NOTE 2: The name of the Library must be in all upper case letters.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHyAAM","label":"Security"}],"ARM Case Number":"TS018475017","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0;7.4.0;7.5.0"}]

Document Information

Modified date:
11 February 2025

UID

ibm17183025

Page Feedback