F.4 SEC$USER_ATTRIBUTES

Additional attributes of users

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

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;

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