F.4 SEC$USER_ATTRIBUTES

Additional attributes of users

Column NameData TypeDescription

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

  1. SELECT
  2.   U.SEC$USER_NAME AS LOGIN,
  3.   A.SEC$KEY AS TAG,
  4.   A.SEC$VALUE AS "VALUE",
  5.   U.SEC$PLUGIN AS "PLUGIN"
  6. FROM SEC$USERS U
  7. LEFT JOIN SEC$USER_ATTRIBUTES A
  8.   ON U.SEC$USER_NAME = A.SEC$USER_NAME
  9.     AND U.SEC$PLUGIN = A.SEC$PLUGIN;
  10.  
  11. LOGIN    TAG     VALUE   PLUGIN
  12. ======== ======= ======= ===================
  13. SYSDBA   <null>  <null>  Srp
  14. ALEX     B       x       Srp
  15. ALEX     C       sample  Srp
  16. SYSDBA   <null>  <null>  Legacy_UserManager