Documentation for RDB$USERS

By: Quinn Wildman

Abstract: RDB$USERS is new system table introduced in InterBase 7.5

RDB$USERS is new system table introduced in InterBase 7.5. It is used for the new Embedded User authentication feature in InterBase 7.5. Below is a list of fields in the table. All fields other than RDB$USER_NAME, RDB$USER_ACTIVE and RDB$PASSWORD are not required and intended to be used as you see fit.
Column name Datatype Length Description
RDB$USER_NAME VARCHAR 128 Unique user name
RDB$SYSTEM_USER_NAME VARCHAR 128 System User Name
RDB$GROUP_NAME VARCHAR 128 Group Name
RDB$UID INTEGER User ID
RDB$GID INTEGER Group ID
RDB$PASSWORD VARCHAR 32 Password (encrypted) Filled in by System.
RDB$USER_ACTIVE CHAR 2 Y or N to indicate whether a user is active or not.
RDB$USER_PRIVILEGE INTEGER User Privilege
RDB$DESCRIPTION BLOB Description
RDB$FIRST_NAME VARCHAR 32 First Name
RDB$MIDDLE_NAME VARCHAR 32 Middle Name
RDB$LAST_NAME VARCHAR 32 Last Name
RDB$DEFAULT_ROLE VARCHAR 67 Default Role

Server Response from: ETNASC03