Add the users management per database (Node Users)

[luronumen]

Since version 3, the Firebird authentication system has evolved considerably, allowing users to be managed through SQL commands in addition to creating users using various plugins (Legacy_UserManager, Srp, etc.) and mappings. In Firebird 3.0 groups of users are allowed per database and no longer per server as it is currently implemented in FlameRobin.

Please add the users management per database by adding the Users node for each database registered with FlameRobin:

And use the following query to identify the database users:

SELECT SEC$USERS.SEC$USER_NAME AS USER_NAME, SEC$USERS.SEC$FIRST_NAME AS FIRST_NAME, SEC$USERS.SEC$MIDDLE_NAME AS MIDDLE_NAME, SEC$USERS.SEC$LAST_NAME AS LAST_NAME, SEC$USERS.SEC$ACTIVE AS "ACTIVE", SEC$USERS.SEC$ADMIN AS "ADMIN", SEC$USERS.SEC$DESCRIPTION AS DESCRIPTION, SEC$USERS.SEC$PLUGIN "PLUGIN", SEC$USER_ATTRIBUTES.SEC$KEY AS "KEY", SEC$USER_ATTRIBUTES.SEC$VALUE AS "VALUE" FROM SEC$USERS LEFT JOIN SEC$USER_ATTRIBUTES ON SEC$USERS.SEC$USER_NAME=SEC$USER_ATTRIBUTES.SEC$USER_NAME AND SEC$USERS.SEC$PLUGIN=SEC$USER_ATTRIBUTES.SEC$PLUGIN ORDER BY USER_NAME, "PLUGIN";

[luronumen]

Retest result on FlameRobin 0.9.3.12: FAIL!

Best Regards, Luciano

[luronumen]

Hi @Jdochoa

Do you have any expectations of implementing this feature?

Thanks in advance, Luciano

[luronumen]

Users is the only node available in Red Expert that is not available in FlameRobin:

[Jdochoa]

hi @luronumen , i work in this in break. maybe it's ready for January.

./jo

[luronumen]

hi @luronumen , i work in this in break. maybe it's ready for January.

./jo

You are the Guy @Jdochoa !

Thank you very much!