The RDB$MODULES system table describes a module as defined by
a user. A module can contain a stored procedure or an external
function. Each module has a header, a declaration section, and
a series of routines. The header and declaration section are
defined in RDB$MODULES. (Each routine is defined by an entry in
RDB$ROUTINES.) A row is stored in the RDB$MODULES table for each
module that is defined by a user. The following table provides
information on the columns of the RDB$MODULES system table.
Data
Column Name Type Summary Description
RDB$MODULE_NAME char(31) Name of the module.
RDB$MODULE_OWNER char(31) Owner of the module. If
the module is an invoker
rights module, this column
is set to NULL. Otherwise,
definers username from this
column is used for definers
rights checking.
RDB$MODULE_ID integer Unique identifier assigned
to this module by Oracle
Rdb.
RDB$MODULE_VERSION char(16) Module version and
checksum. Allows runtime
validation of the module
with respect to the
database.
RDB$EXTENSION_PARAMETERS list Encoded information for
of byte module level declarations.
varying
RDB$MODULE_HDR_SOURCE list Source of the module header
of byte as provided by the definer.
varying
RDB$DESCRIPTION list Description of the module.
of byte
varying
RDB$ACCESS_CONTROL list Access Control List (ACL)
of byte to control access to the
varying module. This value can be
NULL.
RDB$SECURITY_CLASS char(20) Reserved for future use.
RDB$CREATED date vms Set when the module is
created.
RDB$LAST_ALTERED date vms Set when module is altered
by the ALTER, RENAME,
DROP, GRANT and REVOKE
statements.
RDB$MODULE_CREATOR char(31) Creator of this module.
Differentiates between
OWNER and AUTHORIZATION.
RDB$VARIABLE_COUNT integer Number of global variables.