SYSROUTINEPERMS system table

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:
  • Primary key (GRANTEE, ALIASID, GRANTOR)
  • Unique key (ROUTINEPERMSID)
  • Foreign key (ALIASID references SYS.SYSALIASES)

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 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.