AUTHORIZATION_LIST_INFO view

The AUTHORIZATION_LIST_INFO view returns a list of all objects secured by an authorization list.

The information returned is similar to the information available through the Display Authorization List Objects (DSPAUTLOBJ) CL command and the List Objects Secured by Authorization List (QSYLATLO) API.

Authorization: Detail is returned when one of the following is true:

The caller has *READ authority to the authorization list.
The caller is authorized to the QIBM_DB_SECADM function usage identifier.
The caller has *ALLOBJ special authority.

The following table describes the columns in the view. The system name is AUTHL_INFO. The schema is QSYS2.

Table 1. AUTHORIZATION_LIST_INFO view
Column name	System column name	Data type	Description
AUTHORIZATION_LIST	AUTH_LIST	VARCHAR(10)	The authorization list for this object.
SYSTEM_OBJECT_SCHEMA	SYS_DNAME	VARCHAR(10) Nullable	The library that contains the object. Returns the null value if the object is not in the QSYS or QDLS file system.
SYSTEM_OBJECT_NAME	SYS_ONAME	VARCHAR(10) Nullable	The object that is secured by the authorization list. Returns the null value if the object is not in the QSYS or QDLS file system.
SYSTEM_OBJECT_TYPE	SYS_OTYPE	VARCHAR(8)	The system object type of the secured object.
OBJECT_ATTRIBUTE	OBJATTR	VARCHAR(5) Nullable	The attribute for the secured object's type. Returns the null value if the object has no attribute or if it is not in the QSYS or QDLS file system.
OBJECT_SCHEMA	OSCHEMA	VARCHAR(128) Nullable	The SQL schema name for this object. Returns the null value if the object is not in the QSYS or QDLS file system.
OBJECT_NAME	ONAME	VARCHAR(128) Nullable	The SQL name of the object. For an external procedure or an external function, the name will be returned when a single procedure or function exists for that PGM or SRVPGM object. Contains the null value if an SQL name could not be returned.
OBJECT_TYPE	OTYPE	VARCHAR(9) Nullable	The SQL object type. The following values can be returned. ALIAS The object is an SQL alias. FUNCTION The object is an SQL function. INDEX The object is an SQL index. PACKAGE The object is an SQL package. PROCEDURE The object is an SQL procedure. ROUTINE The object is used in SQL by one or more external functions and/or external procedures. SEQUENCE The object is an SQL sequence. TABLE The object is an SQL table. TRIGGER The object is an SQL trigger. TYPE The object is an SQL type. VARIABLE The object is an SQL global variable. VIEW The object is an SQL view. XSR The object is an XML schema repository object. Returns the null value if the object is not an SQL object.
OBJECT_OWNER	OWNER	VARCHAR(10)	The owner of the object.
PRIMARY_GROUP	GROUP	VARCHAR(10) Nullable	The user who is the primary group for the object. Returns the null value if there is no primary group for the object.
TEXT_DESCRIPTION	TEXT	VARCHAR(50) Nullable	The descriptive text for the secured object. Returns the null value if the object is not in the QSYS or QDLS file system.
ASPGRP	ASPGRP	VARCHAR(10)	The name of the ASP device containing the object. A value of *SYSBAS indicates the system ASP and all basic user ASPs.
AUTHORITY_HOLDER	AUT_HOLDER	VARCHAR(3)	Indicates whether the object is an authority holder. NO The object is not an authority holder. YES The object is an authority holder.
PATH_NAME	PATH_NAME	DBCLOB(16M) CCSID 1200 Nullable	The path name for the object that is secured by the authorization list. Returns the null value if the object is in the QSYS or QDLS file system.
DLO_NAME	DLO_NAME	VARCHAR(12) Nullable	The document library object (DLO) name for the object. Returns the null value if OBJECT_TYPE is not DOC (document) or FLR (folder).
FOLDER_PATH	FOLDER	VARCHAR(63) Nullable	The name of the folder that contains the DLO object. Returns the null value if the object is not in a folder.

Example

Return information about all the object secured by authorization list APP1.

SELECT * FROM QSYS2.AUTHORIZATION_LIST_INFO WHERE AUTHORIZATION_LIST = 'APP1';