SYSROUTINEAUTH

The SYSROUTINEAUTH view contains one row for every privilege granted on a routine. Note that this catalog view cannot be used to determine whether a user is authorized to a routine because the privilege to use a routine could be acquired through a group user profile or special authority (such as *ALLOBJ).

The following table describes the columns in the SYSROUTINEAUTH view:

Table 1. SYSROUTINEAUTH view
Column Name	System Column Name	Data Type	Description
GRANTOR	GRANTOR	VARCHAR(128) Nullable	Reserved. Contains the null value.
GRANTEE	GRANTEE	VARCHAR(128)	The user profile to which the privilege is granted.
ROUTINE_SCHEMA	RTNSCHEMA	VARCHAR(128)	Name of the schema
ROUTINE_NAME	RTNNAME	VARCHAR(128)	Name of the routine
SPECIFIC_SCHEMA	SPECSCHEMA	VARCHAR(128)	Specific name of the schema
SPECIFIC_NAME	SPECNAME	VARCHAR(128)	Specific name of the routine
PRIVILEGE_TYPE	PRIVTYPE	VARCHAR(10)	The privilege granted: ALTER The privilege to alter the routine. EXECUTE The privilege to execute the routine.
IS_GRANTABLE	GRANTABLE	VARCHAR(3)	Indicates whether the privilege is grantable to other users. NO The privilege is not grantable. YES The privilege is grantable.
AUTHORIZATION_LIST	AUTL	VARCHAR(10) Nullable	If the privilege is granted through an authorization, contains the name of the authorization list. Contains the null value if the privilege is not granted through an authorization list.