F.4. SEC$USER_ATTRIBUTES

Additional attributes of users

Column NameData TypeDescription

SEC$USER_NAME

CHAR(31)

Username

SEC$KEY

VARCHAR(31)

Attribute name

SEC$VALUE

VARCHAR(255)

Attribute value

SEC$PLUGIN

CHAR(31)

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