The SYSROUTINEPERMS table stores the permissions that have been granted to routines.
The column information for the SYSTABLEPERMS table is listed in the following table:
|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 or role to which 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.|