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