SYSROUTINEPERMS

The SYSROUTINEPERMS table stores the permissions that have been granted to routines.

Each routine EXECUTE permission is specified in a row in the SYSROUTINEPERMS table. The keys for the SYSROUTINEPERMS table are:

The column information for the SYSTABLEPERMS table is listed in the following table:

Column Name	Type	Length	Nullability	Contents
ROUTINEPERMSID	CHAR	36	false	Used by the dependency manager to track the dependency of a view, trigger, or constraint on the routine level permissions.
GRANTEE	VARCHAR	30	false	The authorization ID of the user to whom the privilege is granted.
GRANTOR	VARCHAR	30	false	The authorization ID of the user who granted the privilege. Privileges can be granted only by the object owner.
ALIASID	CHAR	36	false	The ID of the object of the required permission. If PERMTYPE='E' the ALIASID is a reference to the SYS.SYSALIASES table. Otherwise the ALIASID is a reference to the SYS.SYSTABLES table.
GRANTOPTION	CHAR	1	false	Specifies if the GRANTEE is the owner of the routine. Valid values are Y and N.