HELPLIB.HLB  —  SQL72  System Tables, RDB$MODULES
    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.
Close Help