VMS Help  —  SQL72  System Tables, RDB$PROFILES
    The RDB$PROFILES system table contains information about each
    profile, user and role defined for the database. The following
    table provides information on the columns of the RDB$PROFILES
    system table. See also the related RDB$GRANTED_PROFILES system
    table.

                                Data
    Column Name                 Type      Summary Description

    RDB$CREATED                 date vms  time and date when profile
                                          entry was created.
    RDB$LAST_ALTERED            date vms  time and date when profile
                                          entry was last altered.
    RDB$DESCRIPTION             list      Comment for this entry.
                                of byte
                                varying
    RDB$EXTENSION_              list      Extra definitions such as
    PARAMETERS                  of byte   default transaction.
                                varying
    RDB$SYSTEM_FLAG             integer   Set to TRUE (1) if this
                                          is a system define role
                                          or user, otherwise it is
                                          set to FALSE (0). When
                                          the RDB$SYSTEM_FLAG is
                                          set these entries may
                                          not be deleted by a DROP
                                          statement.
    RDB$FLAGS                   integer   Flags.
    RDB$DEFINE_ACCESS           integer   Reserved for future use.
    RDB$CHANGE_ACCESS           integer   Reserved for future use.
    RDB$DELETE_ACCESS           integer   Reserved for future use.
    RDB$PROFILE_ID              integer   This is a unique identifier
                                          generated for each USER,
                                          PROFILE and ROLE added to
                                          the database.
    RDB$PROFILE_TYPE            integer   Class of profile
                                          information: role (1),
                                          user (3), profile (0).
    RDB$PROFILE_NAME            char(31)  Name of the user, profile
                                          or role. This name
                                          is unique within the
                                          RDB$PROFILES table.
    RDB$PROFILE_CREATOR         char(31)  Creator of entry.
Additional Information: explode extract
RDB$FLAGS
Close Help