The Firebird 5.0 Language Reference

Monitoring TablesPlugin tables

`SEC$USER_ATTRIBUTES`

Additional attributes of users

Column Name Data Type Description

Column Name	Data Type	Description
`SEC$USER_NAME`	`CHAR(63)`	Username
`SEC$KEY`	`VARCHAR(63)`	Attribute name
`SEC$VALUE`	`VARCHAR(255)`	Attribute value
`SEC$PLUGIN`	`CHAR(63)`	Authentication plugin name that manages this user

SEC$USER_NAME

CHAR(63)

Username

SEC$KEY

VARCHAR(63)

Attribute name

SEC$VALUE

VARCHAR(255)

Attribute value

SEC$PLUGIN

CHAR(63)

Authentication plugin name that manages this user

Displaying a list of users and their attributes

SELECT
  U.SEC$USER_NAME AS LOGIN,
  A.SEC$KEY AS TAG,
  A.SEC$VALUE AS "VALUE",
  U.SEC$PLUGIN AS "PLUGIN"
FROM SEC$USERS U
LEFT JOIN SEC$USER_ATTRIBUTES A
  ON U.SEC$USER_NAME = A.SEC$USER_NAME
    AND U.SEC$PLUGIN = A.SEC$PLUGIN;

LOGIN    TAG     VALUE   PLUGIN
======== ======= ======= ===================
SYSDBA   <null>  <null>  Srp
ALEX     B       x       Srp
ALEX     C       sample  Srp
SYSDBA   <null>  <null>  Legacy_UserManager