RDB$USERS

From InterBase
Jump to: navigation, search

Go Up to System Tables


RDB$USERS only permits users in that system table access to the database.

RDB$USERS
Column name Datatype Length Description

RDB$USER_NAME (RDB$USER_NAME)

VARCHAR(128)

CHARACTER SET UNICODE_FSS Nullable

RDB$SYSTEM_USER_NAME (RDB$USER_NAME)

VARCHAR(128)

CHARACTER SET UNICODE_FSS Nullable

RDB$GROUP_NAME (RDB$USER_NAME)

VARCHAR(128)

CHARACTER SET UNICODE_FSS Nullable

RDB$UID (RDB$UID)

INTEGER

Nullable

RDB$GID (RDB$GID)

INTEGER

Nullable

RDB$PASSWORD (RDB$PASSWORD)

VARCHAR(32)

CHARACTER SET OCTETS Nullable

RDB$USER_ACTIVE (RDB$USER_ACTIVE)

CHAR(2)

Nullable

RDB$USER_PRIVILEGE (RDB$USER_PRIVILEGE)

INTEGER

Nullable

RDB$DESCRIPTION (RDB$DESCRIPTION)

BLOB

segment 80, subtype TEXT CHARACTER SET UNICODE_FSS Nullable

RDB$FIRST_NAME (RDB$NAME_PART)

VARCHAR(32)

CHARACTER SET UNICODE_FSS Nullable

RDB$MIDDLE_NAME (RDB$NAME_PART)

VARCHAR(32)

CHARACTER SET UNICODE_FSS Nullable

RDB$LAST_NAME (RDB$NAME_PART

VARCHAR(32)

CHARACTER SET UNICODE_FSS Nullable

RDB$DEFAULT_ROLE (RDB$USER)

CHAR(67)

CHARACTER SET UNICODE_FSS Nullable

RDB$PASSWORD_DIGEST (RDB$PASSWORD_DIGEST)

VARCHAR(16)

Nullable