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