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.

1  –  RDB$FLAGS

    Represents flags for RDB$PROFILES system table.

    Bit
    Position   Description

    0          The user entry is disabled (ACCOUNT LOCK).
    1          Means that the user/role is identified externally.
    2          Reserved for future use.
    3          This is a system role.
    4          Means the user is assigned a profile.