F.3. SEC$USERS

Lists users in the current security database.

Column NameData TypeDescription

SEC$USER_NAME

CHAR(31)

Username

SEC$FIRST_NAME

VARCHAR(32)

First name

SEC$MIDDLE_NAME

VARCHAR(32)

Middle name

SEC$LAST_NAME

VARCHAR(32)

Last name

SEC$ACTIVE

BOOLEAN

true - active, false - inactive

SEC$ADMIN

BOOLEAN

true - user has admin role in security database, false otherwise

SEC$DESCRIPTION

BLOB TEXT

Description (comment) on the user

SEC$PLUGIN

CHAR(31)

Authentication plugin name that manages this user

☝
Important

Multiple users can exist with the same username, each managed by a different authentication plugin.