Security Services

These views, procedures, and functions provide security information.

AUTHORIZATION_LIST_INFO view
The AUTHORIZATION_LIST_INFO view returns a list of all objects secured by an authorization list.
AUTHORIZATION_LIST_USER_INFO view
The AUTHORIZATION_LIST_USER_INFO view returns a list of all authorization lists and their authorities.
DRDA_AUTHENTICATION_ENTRY_INFO view
The DRDA_AUTHENTICATION_ENTRY_INFO view returns user server authentication entry information.
FUNCTION_INFO view
The FUNCTION_INFO view contains details about function usage identifiers.
FUNCTION_USAGE view
The FUNCTION_USAGE view contains function usage configuration details.
GROUP_PROFILE_ENTRIES view
The GROUP_PROFILE_ENTRIES view contains one row for each user profile that is part of a group profile.
OBJECT_PRIVILEGES view
The OBJECT_PRIVILEGES view returns a row for every user authorized to an object, along with their associated object and data authorities.
SET_COLUMN_ATTRIBUTE procedure
The SET_COLUMN_ATTRIBUTE procedure sets the SECURE attribute for a column so variable values used for the column cannot be seen in the database monitor or plan cache.
SQL_CHECK_AUTHORITY scalar function
The SQL_CHECK_AUTHORITY scalar function returns an indication of whether the user is authorized to query the specified *FILE object.
USER_INFO view
The USER_INFO view contains information about user profiles.

Parent topic: IBM i Services