F.3 SEC$USERS

Lists users in the current security database.

Column Name Data Type Description
SEC$USER_NAME CHAR(63) 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(63) Authentication plugin name that manages this user

Important

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