1.1.1

• Foreign key (ALIASID references SYS.SYSALIASES)
Table 28: SYSROUTINEPERMS system table
ContentsNullableLengthTypeColumn Name
Used by the dependency
manager to track the
No36CHARROUTINEPERMSID
dependency of a view,
trigger, or constraint on
the routine level
permissions
The authorization ID of
the user or role to which
the privilege is granted
No128VARCHARGRANTEE
The authorization ID of
the user who granted the
No128VARCHARGRANTOR
privilege. Privileges can
be granted only by the
object owner.
The ID of the object of the
required permission. If
No36CHARALIASID
PERMTYPE='E', the
ALIASID is a reference to
the SYS.SYSALIASES
table. Otherwise, the
ALIASID is a reference to
the SYS.SYSTABLES
table.
Specifies if the
GRANTEE is the owner
No1CHARGRANTOPTION
of the routine. Valid
values are 'Y' and 'N'.
SYSSCHEMAS
Describes all schemas in the distributed system.
Table 29: SYSSCHEMAS system table
ContentsNullableLengthTypeColumn Name
Unique identifier for the
schema
No36CHARSCHEMAID
Schema nameNo128VARCHARSCHEMANAME
The authorization
identifier of the owner of
the schema
No128VARCHARAUTHORIZATIONID
673
System Tables