SYSROUTINEPERMS

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:
  • Primary key (GRANTEE, ALIASID, GRANTOR)
  • Unique key (ROUTINEPERMSID)
  • Foreign key (ALIASID references SYS.SYSALIASES)
Table 1. SYSROUTINEPERMS system table
Column Name Type Length Nullable Contents
ROUTINEPERMSID CHAR 36 No Used by the dependency manager to track the dependency of a view, trigger, or constraint on the routine level permissions
GRANTEE VARCHAR 128 No The authorization ID of the user or role to which the privilege is granted
GRANTOR VARCHAR 128 No The authorization ID of the user who granted the privilege. Privileges can be granted only by the object owner.
ALIASID CHAR 36 No 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 No Specifies if the GRANTEE is the owner of the routine. Valid values are 'Y' and 'N'.