IBM Support

How do you get a listing of all objects secured by an Authorization List

Question & Answer


Question

How do you get a listing of all objects secured by an Authorization List

Cause

With the introduction of the IBM i SQL Service AUTHORIZATION_LIST_INFO view, you can create an SQL report containing all of the objects secured by an Authorization List.  
 
Authorization: Detail is returned when one of the following is true:
  • The user has *READ authority to the authorization list.
  • The user is authorized to the Database Security Administrator function of the IBM i. The Change Function Usage (CHGFCNUSG) command, with a function ID of QIBM_DB_SECADM, can be used to change the list of users allowed to use the function.
  • The user has *ALLOBJ special authority.
Example 1:  Listing of all objects secured by authorization list V6AUTL:
Using the RUN SQL Scripts tool, run the following SQL Statement:
  SELECT AUTHORIZATION_LIST,
       SYSTEM_OBJECT_SCHEMA,
       SYSTEM_OBJECT_TYPE,
       ASPGRP,
       PATH_NAME,
       DLO_NAME,
       FOLDER_PATH
    FROM QSYS2.AUTHORIZATION_LIST_INFO
    WHERE AUTHORIZATION_LIST = 'V6AUTL'
image 6083
Example 2:  Listing of library type objects secured by authorization list V6AUTL:
  SELECT AUTHORIZATION_LIST,
       SYSTEM_OBJECT_SCHEMA AS Library,
       SYSTEM_OBJECT_NAME AS Object,
       SYSTEM_OBJECT_TYPE AS Object_Type
    FROM QSYS2.AUTHORIZATION_LIST_INFO
    WHERE AUTHORIZATION_LIST = 'V6AUTL'
          AND system_object_name NOTNULL
image 6085
Example 3:  Listing of IFS type objects secured by authorization list V6AUTL:
Using the RUN SQL Scripts tool, run the following SQL Statement:
  SELECT AUTHORIZATION_LIST,         SYSTEM_OBJECT_TYPE,         PATH_NAME      FROM QSYS2.AUTHORIZATION_LIST_INFO      WHERE AUTHORIZATION_LIST = 'V6AUTL'            AND path_name NOTNULL
image 6086
More information on the AUTHORIZATION_LIST_INFO view can be found:

[{"Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHyAAM","label":"Security"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0;7.3.0;7.4.0"}]

Document Information

Modified date:
27 November 2020

UID

ibm16332293

Page Feedback