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';